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
SUMMARY
To select a single defined name from a macro in Microsoft Excel, use the following statement:
=SELECT(name)
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
=SELECT("name1,name2,name3")
where "name1," "name2," and "name3" are all defined areas on a worksheet or macro sheet.
REFERENCES
"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:
Keywords :
Version :
Platform :
Issue type :
Technology :
Last Reviewed: March 15, 1999 |