Microsoft KB Archive/25654

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 13:53, 21 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.