Excel: Obtaining a Count of the Currently Open WindowsLast reviewed: November 2, 1994Article ID: Q66383 |
SUMMARYTo count the number of windows that are currently open in Microsoft Excel, including those that are hidden, enter the following commands on a macro sheet:
+---+---------------------+ | | A | +---+---------------------+ | 1 | WindowCount | +---+---------------------+ | 2 | =COLUMNS(WINDOWS()) | <-- Enter as an array formula by pressing +---+---------------------+ COMMAND+ENTER. | 3 | =Return() | +---+---------------------+(Note: This will not count Excel 3.00 Add-in macros) To define the commands as a macro, do the following:
Note: To display the values that the macro commands return instead of the formulas, choose Display from the Options menu, deselect Formulas, and click OK, or press COMMAND+~ (TILDE) to toggle the display between formulas and values.
|
KBCategory: kbother
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |