Scanning Code

[Adept]

I would like to take each item in the .Names collection and check my code
to determine if I am actually using the Defined Name.

I can use ListNames to get the names, I know. But how can I iterate thru
the array and look for matches?

I suspect I need to use some form of an automated+ACI-FIND+ACI- .

Any suggestion appreciated.

The Old Grey Geek
--


The Old Grey Geeks' Lament

And we carried our bits in a bucket,
And our mainframe weighed 900 tons,
And we programmed in ones and in zeros
And sometimes we ran out of ones.

 

[Dave Peterson]

Get a copy of 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

Remember that even if you find your name isn't used in any worksheet formula, it
may be used in your VBA code.