MrExcel Publishing
Your One Stop for Excel Tips & Solutions

List of defined names (ranges)

Posted by Fossie on June 12, 2001 1:56 AM


Is there anybody who knows how to get a list of the Defined Names (ranges) specified in a certain Workbook. I need this to automate a task, but I don't know when I get the excelfile, how many ranges there are and the names of them.

I'm using Excel97 files.

I hope someone can help me solving this issue.


Posted by by on June 12, 2001 3:39 AM

Try 'F3' then paste link...

Posted by IML on June 12, 2001 11:19 AM

ASAP Utilities

Check out the ASAP Utility. This option is under under information, list all range names