Microsoft KB Archive/25654

{|
 * width="100%"|

Excel: Selecting a Range with Defined Names

 * }

SUMMARY
If you have defined two cells on your Microsoft Excel worksheet using the Define Name command on the Formula menu, you can use the following command to allow a macro to select the range between the two cells

  =SELECT("name1:name2")

where "name1" and "name2" are the defined names of cell 1 and cell 2 on the worksheet, respectively.

Additional query words:

Keywords :

Version :

Platform :

Issue type :

Technology :