How to report on WHAT range names are used

[ssGuru]

How can I generate a report, list or whatever that will show which of
my 175 named ranges ARE used in this workbook?

Dennis

 

[ward376]

insert>name>paste will show your names and ranges

Cliff Edwards

 

[ward376]

In projects where I use a lot of names, I usually keep a sheet with
this code in it:

Private Sub Worksheet_Activate()
Cells.Clear
Cells(1, 1).ListNames
End Sub

Cliff Edwards

 

[Dave Peterson]

Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

You'll find it very valuable.

 

[George Nicholson]

You want a list of all Named ranges or just a list of Named ranges in use?
If the latter, define "use".

 

[ssGuru]

I want a list of all range names. Sure I know how to use INSERT/NAME/
PASTE to get a list of my names. I always make a hidden sheet part of
any project.

But now I ALSO want that list to show me WHETHER a name is in USE.
Use means to me that it is contained in a formula, code,
DataValidation, or reference within a workbook.

I downloaded JKPs excellent NameManager utility and it seems to offer
a check on whether a name is in use but I haven't been able to get it
to produce a list for me of "used" names. Says it takes a LONG time
but nothing shows whether it is still working and its been a LONG
time.

Is there any other tool, code or method that will provide such useful
information?

Dennis