Viewing List of Named Ranges

[Graham Parkinson]

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

 

[R.VENKATARAMAN]

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.

 

[Norman Jones]

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