Excel: Selecting a Range with Defined Names

ID: Q25654

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        :

Last Reviewed: March 11, 1999