Macro determines the range name of the active cell in Excel (811438)
The information in this article applies to:
- Microsoft Office Excel 2003
- Microsoft Excel 2002
- Microsoft Excel 2000
- Microsoft Excel 2001 for Mac
- Microsoft Excel X for Mac
SUMMARYThis article provides a macro that searches through all the
names in the workbook to find which name or names the active cell is currently
located in. For example, if the current active cell is A5 on sheet1 and there
is a defined name "Test" that refers to "sheet1!A1:C5," the macro will display
a message stating:The activecell is in the range named
"Test"
Modification Type: | Major | Last Reviewed: | 6/7/2006 |
---|
Keywords: | kbhowto KB811438 |
---|
|