Viewing List of Named Ranges
 

Is there someway of being able to print a list of all the
Named Ranges and their formulas in one long list? A way
to do this could be to link the range formulas to various
cells within a spreadsheet, and then just print that. Is
that possible?

Thanks
Graham

highlight any cell in unused portion
insert-name-paste
in the paste name window
click <paste list at the bottom

this will give you all the names of the workbook and also what each name
refers to.

is this what you want.

Graham Parkinson wrote in message
...
Is there someway of being able to print a list of all the
Named Ranges and their formulas in one long list? A way
to do this could be to link the range formulas to various
cells within a spreadsheet, and then just print that. Is
that possible?

Thanks
Graham

Hi Graham,

Youi may wish to look at Jan Karel Pieterse's invaluable Name Manager Addin
which is freely downloadable from:

http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm


---
Regards,
Norman



"Graham Parkinson" wrote in message
...
Is there someway of being able to print a list of all the
Named Ranges and their formulas in one long list? A way
to do this could be to link the range formulas to various
cells within a spreadsheet, and then just print that. Is
that possible?

Thanks
Graham