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.

Articles for product: Microsoft Excel 2000 Standard Edition

Article ID Article Title Hidden
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
213640 XL2000: How to Continue a Visual Basic Statement from One Line to the Next
213642 XL2000: Macro to Append Text from One Text File to Another
213643 XL2000: How to Use Application.Match to Locate Date Values on a Worksheet
213644 XL2000: How to Automatically Set Min and Max Scale for Y-Axis
213645 XL2000: How to Use a Custom Function in Another Workbook
213647 XL2000: Macro to Open All Linked Workbooks
213648 HOW TO: Set a Print Area by Using a Defined Name in Excel 2000
213649 XL2000: Sample Macro Code to Change Case of Text
213650 Error opening file that refers to shortcut
213652 XL2000: Default Property/Methods for Objects in Visual Basic
213653 XL2000: Cannot Use Array as Source Argument with SeriesCollection
213654 XL: All PageSetup Settings Are Recorded into Macro
213655 XL2000: Error Getting the Value of a Name in Visual Basic
213657 XL2000: Error Message When Using Paste Method Without Moving Active Cell
213661 XL2000: Unlocked Cells Not Underlined with Protection Enabled
213662 XL2000: Macro Cannot Scroll Chart Sheet
213663 XL2000: Workbook Created with Automation Is Hidden When Opened
213664 XL2000: Macro Works Differently on .wk3 Files Than in Microsoft Excel 5.0
213665 XL2000: IsDate Function Incorrectly Identifies Some Expressions
213671 XL2000: Arc/Block Arc Adjusted Incorrectly When You Run Macro
213672 XL2000: "Can't Execute Code in Break Mode" When Running Macro
213673 XL2000: RefEdit Control Still Appears After You Close UserForm
213674 XL2000: "Compile Error" Running Macro That Changes Margins in Print Preview
213675 XL2000: "Cannot jump to 'Application' because it is hidden."
213677 XL2000: "Run-Time Error '4599'" Running DDE Macro to Control Excel
213680 XL2000: How to Change the Font in a Cell Comment
213682 XL2000: "Out of Memory" Error Running Sub Procedure
213683 You receive a "Not enough memory" error message when you open a workbook with a chart
213684 XL2000: Function That Uses the ActiveCell Property Returns Incorrect Result