Printing a list of all named ranges

[Joe Smith]

Is there a way to print a list of all the named ranges
used within a worksheet/workbook along with their
respective references?

Thanks in advance.

 

[Paul B]

Joe, here is one way, the free add in from ASAP will do it, and a lot more,
have a look at it here
http://www.asap-utilities.com/ what you want is under information, list all
range names

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[J.E. McGimpsey]

take a look here:

http://www.mcgimpsey.com/excel/listnames.html

where there's a link to Jan Karel Pieterse and Charles Williams'
superb NameManager add-in as well as a macro of mine.

 

[Tom Ogilvy]

Insert=>Name=>Paste and designate a place to put the information.