Microsoft KB Archive/51629
Excel: Selecting Multiple Defined Names from a Macro
The information in this article applies to:
- Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
- Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0
- Microsoft Excel for OS/2, versions 2.2, 3.0
To select a single defined name from a macro in Microsoft Excel, use the following statement:
where "name" is a defined area on the worksheet or macro sheet.
To select multiple defined names, the names must be enclosed in quotation marks and separated by commas, as in the following example
where "name1," "name2," and "name3" are all defined areas on a worksheet or macro sheet.
"Microsoft Excel Function Reference" version 4.0, pages 378-379
"Microsoft Excel Function Reference" version 3.0, pages 209-210
"Microsoft Excel Functions and Macros" version 2.2, pages 274-275
Additional query words:
Issue type :
Last Reviewed: March 15, 1999