Microsoft KB Archive/25654

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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 :


Last Reviewed: March 11, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.