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.

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 **

"Joe Smith" wrote in message
...
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.

take a look he

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.


In article ,
"Joe Smith" wrote:

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.

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

--
Regards,
Tom Ogilvy

"Joe Smith" wrote in message
...
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.