Scanning Code

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.

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.

Adept wrote:
>
> 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