Microsoft KB Archive/51629

{|
 * width="100%"|

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 &quot;name&quot; 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(&quot;name1,name2,name3&quot;)

where &quot;name1,&quot; &quot;name2,&quot; and &quot;name3&quot; are all defined areas on a worksheet or macro sheet.