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.

  1. Home
  2. Products
  3. Microsoft Excel 2000 Standard Edition

Articles for product: Microsoft Excel 2000 Standard Edition

Article ID Article Title Hidden
213301 XL2000: Application.Interactive Value Not Reset When Macro Stops
213303 XL2000: How to a Make Spinner with a Minimum Value Less Than Zero
213313 XL2000: How to Programmatically Sum Only the Visible Cells in a Range
213316 XL2000: Macro to Link a Range of Cells in Word
213318 XL2000: How to Programmatically Insert Blank Rows in a Worksheet
213323 XL2000: How to Programmatically Measure the Visible Range in Points
213326 XL2000: Error When You Use Array with Range Method
213328 XL2000: Min and Max Functions Do Not Work Properly with Arrays
213330 XL2000: How to Count Rows Displayed After Data Has Been Filtered
213333 XL2000: How to Programmatically Select the Current Data Area Without Selecting the First Row
213337 XL2000: How to Programmatically Subtract or Sum Two Ranges of Data
213343 XL: How to Put Folder Contents into a Worksheet
213351 XL2000: How to Create a Chart with Non-Contiguous Ranges
213352 XL2000: How to Programmatically Create a Chart Without Selecting a Range of Cells
213353 XL2000: You Receive "User-Defined Type Not Defined" Error Message When Using Data Access Objects
213355 How to find duplicate entries in a column by using a macro in Excel 2000
213358 XL2000: How to Programmatically Make Sure That Only Numbers Are Entered in a Column
213363 XL2000: How to Programmatically Insert Data from a List Box into the Active Cell
213365 XL2000: How to Pass Variables in Visual Basic for Applications Macros
213369 XL2000: How to Programmatically Display All Files in a Folder
213371 XL2000: How to Display the Open and Save As Dialog Boxes
213373 XL2000: Visual Basic Macro for Validating Data upon Entry
213375 XL2000: How to Return the Address of the Cell with the Largest or Smallest Value
213379 XL2000: Error Programmatically Accessing Data Series on a Chart
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