Excel: Selecting Multiple Defined Names from a Macro

ID: Q51629

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 :