Excel Macro Named Range Shortcut

Microsoft Excel 2003 (full product)
October 5, 2010 at 15:13:39
Specs: Windows
I am looking for an Excel VBA macro that will select and clear the contents of the named range box on the top left of the Excel window. I have found something online previously, but I have since lost the code and am not able to relocate the code.

The advantage of this macro is that I do not have to type alt+I+N+D in order to define a named range. Instead I can type a macro shortcut command and then type my desired named range name for the cells I have highlighted.

See More: Excel Macro Named Range Shortcut

Report •

October 5, 2010 at 19:25:00
re: "I am looking for an Excel VBA macro..."

Good luck with your search.

If we can be of any assistance, feel free to let us know.

Report •
Related Solutions

Ask Question