Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Offline KB Article List

Article ID Article Title Hidden
213564 XL2000: ParamArray Must Be Declared as an Array of Variant
213567 XL2000: ParamArrays Are Always Zero-Based
213568 XL2000: Cannot Paste Array Formula in Its Original Cell
213569 XL2000: Menu Added in Wrong Position on Menu Bar
213570 XL2000: Reference to DAO 3.0 Changes to DAO 3.5 When File Opened
213571 XL2000: No "Record at Mark" Feature in Microsoft Excel
213572 XL2000: Clicking Cancel Button May Not Dismiss UserForm
213574 XL2000: How to Display a UserForm Whose Name Is in a Variable
213575 XL2000: Using a Macro to Activate a Chart Changes the Selection
213577 "ActiveX component can't create object" error message when you use Data Access Objects 3.0 (DAO 3.0) in Excel 2000
213578 XL2000: How to Assign a Macro to an ActiveX Worksheet Control
213579 XL2000: Select Method May Select More Cells Than Expected
213580 XL2000: Text Property Limited to 1,024 Characters
213581 VBA code "behind" a worksheet or a workbook may not work in Excel
213582 XL2000: Problems When You Use Macro to Add Control to UserForm
213583 XL2000: Unable to Show UserForms in Other Projects
213587 XL2000: Cannot Add Macros to the Tools Menu
213589 XL2000: "Type Mismatch" Comparing String Variable to Boolean
213590 XL2000: Worksheet_Change Does Not Run When Worksheet Sorted
213591 XL2000: Macro Stops Running When Its Workbook Is Closed
213593 XL2000: Date Returned in a Macro Is Four Years Too Early
213595 XL2000: Error Message: Name Conflicts with Existing Module, Project, or Object Library
213598 You cannot use the PrintOut method when the custom dialog box is visible
213602 XL2000: CreateObject and GetObject Work Differently
213604 XL2000: Cannot Move or Copy Sheet After Last Sheet
213606 XL2000: Excel Hangs When You Programmatically Save a Workbook
213607 XL2000: Sample Macro to Add or Place Object in Relation to a Range
213608 XL2000: How to Check Spelling for Worksheet Objects Only
213613 XL2000: How to Create Yes and No Buttons for a Custom Message Box
213614 XL2000: How to Use Input Boxes with Visual Basic for Applications
213615 How to add the workbook path to the footer in Excel 2000
213617 XL2000: Sample Macro That Won't Allow User to Cancel Dialog Box
213618 XL2000: Inserting and Formatting Text in Headers and Footers
213619 XL2000: How to Use Dynamic Arrays in a Macro
213621 XL2000: Macro to Loop Through All Worksheets in a Workbook
213622 XL2000: Macro to Search for Cell Formats: Font, Border, and Interior
213623 XL2000: How to use a Macro to Enter Cell Note Text in a Text Box
213624 HOW TO: Create an Auto_Open Macro to Show the Data Form Dialog Box in Excel 2000
213625 XL2000: Sample Macro to Sort List Based on Custom Sort Order
213626 XL2000: Visual Basic Examples Using DDE
213627 XL2000: How to Display Top 10 Records with a Macro
213628 XL2000: How to Control the AutoFilter with a Macro
213630 How to use the IF THEN ELSE statement and the SELECT CASE statement in examples written in Visual Basic for Excel
213631 XL2000: Sample Macro to Insert/Delete Rows or Columns on Multiple Sheets
213632 XL2000: How to Return Data from a Dialog Box to a Worksheet
213633 XL2000: How to Show Quotation Marks in Function Results and Macros
213635 XL2000: How to Create a Macro That Opens Multiple Selected Files
213637 XL2000: How to Use "On Error" to Handle Errors in a Macro
213638 How to create a macro that counts comments
213639 XL2000: How to Create and Use a Workbook_BeforeClose Procedure