Microsoft KB Archive Search

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
213381 XL2000: Macro Example to Return Item from a Worksheet Control
213383 XL2000: Macro Code to Check Whether a File Is Already Open
213385 XL2000: How to Programmatically Delete Defined Names with Links
213387 XL2000: How to Programmatically Suppress an Error Value Returned by a Formula
213392 XL2000: Visual Basic Macro to Convert Number to a Different Base
213394 XL2000: Changing Protected Document's Properties with Visual Basic Macro
213395 XL2000: Visual Basic for Applications Procedure to Open or Activate a Workbook
213398 OFF2000: How to Display All Menu Commands
213401 XL2000: FitToPagesWide or FitToPagesTall Does Not Affect Page Setup
213403 XL2000: Custom Function to Turn Nonadjacent Cells into an Array
213405 XL2000: Range Command in Macro Selects Cells from the Entire Current Range
213411 XL2000: Data Map Objects Limited to RefreshMap Command
213413 Visual Basic macro to show active cell's range names in Excel
213416 XL2000: How to Programmatically Save All Open Workbooks
213418 XL2000: How to Obtain the SQL Statement for a PivotTable
213420 XL2000: ActivatePrevious Method Uses Z-Order Defined by User
213422 XL2000: How to Use Macros to Set Row Height and Column Width
213424 XL2000: How to Control the Appearance of the Mouse Pointer While a Macro Runs
213429 XL2000: TEXT(MONTH(NOW()),"mmm") Always Returns "Jan"
213430 XL2000: How to Run a WordBasic Macro from a Microsoft Excel Macro
213431 XL2000: Macro Doesn't Function on Multiple Sheets in Group Mode
213432 XL2000: Sample Macro to Retrieve Defined Name of the ActiveCell
213435 XL2000: Cannot Display Dialog Box from VBA Macro If Workbook Is Hidden
213437 XL2000: How to Programmatically Delete and Restore a Menu That Contains a Submenu
213438 How to programmatically select every nth row in a range in Excel
213440 XL2000: Visual Basic Macros That Add or Remove Hidden Apostrophes
213443 XL2000: Visual Basic Macro to Break Chart Links
213444 XL2000: How to Enter a Second Line in a Message Box
213446 XL2000: Changing an Integer to an Excel Serial Number
213447 XL: Visual Basic Module to Create a Gantt Chart
213451 XL2000: Sample Visual Basic Procedure to Print Range of Cells
213455 XL2000: Data Fields Are Not Included in PivotFields Collection
213456 XL2000: How to Remove the Control Menu and Program Window Controls
213461 XL2000: Cannot Trap No or Cancel in "Replace Existing" Dialog Box
213464 XL2000: How to Programmatically Increment a Date With a Spinner
213465 XL2000: Visual Basic Macro to Change Between Relative and Absolute References
213469 XL2000: Visual Basic Procedure to Change the Standard Font
213471 XL2000: How to Use Visual Basic to Play an AVI File
213472 XL2000: How to Use Visual Basic Code to Total Rows and Columns in an Array
213473 XL2000: A Visual Basic Nested Case Statement Example
213474 XL2000: Visual Basic Code to Use Instead of DIRECTORIES()
213475 XL2000: User-Defined Function to Place Sheet Name in a Cell
213476 XL: Unexpected Results with Mixed Text and Numbers in Lookup Table
213477 VBA macro to concatenate columns of data in Excel
213481 XL2000: Calculating Elapsed Time for a Visual Basic Procedure
213484 XL2000: How to Return Multiple Values from a Custom Function
213486 XL2000: Branching to Other Sections of Code with GoTo and Call
213487 XL2000: Visual Basic for Applications Macro to Hide and Restore All Toolbars
213488 XL2000: Cells.Find Returns Error Message When No Match Found
213489 Add-ins do not load when using the CreateObject command in Excel