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 :