I have inherited an excel file filled to the brim with obsolete name
definitions, numbering in the hundreds.

I would like a macro that loops through these names, see where they refer
to, and if they refer to any #REF!, or a particular external file that no
longer exist, to delete the name itself.

Any help would be appreciated.
Thanks

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

hugehead wrote:
>
> I have inherited an excel file filled to the brim with obsolete name
> definitions, numbering in the hundreds.
>
> I would like a macro that loops through these names, see where they refer
> to, and if they refer to any #REF!, or a particular external file that no
> longer exist, to delete the name itself.
>
> Any help would be appreciated.
> Thanks

--

Dave Peterson

Thanks, I used it and believe it or not, the excel file had approximately
18,000 (eighteen thousand) invalid names.

The add-in took about 5 minutes just to display the list.

Cheers,

"Dave Peterson" wrote:

> 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
>
> hugehead wrote:
> >
> > I have inherited an excel file filled to the brim with obsolete name
> > definitions, numbering in the hundreds.
> >
> > I would like a macro that loops through these names, see where they refer
> > to, and if they refer to any #REF!, or a particular external file that no
> > longer exist, to delete the name itself.
> >
> > Any help would be appreciated.
> > Thanks
>
> --
>
> Dave Peterson
>

Wow! That's a lot of names and a lot of invalid names!

hugehead wrote:
>
> Thanks, I used it and believe it or not, the excel file had approximately
> 18,000 (eighteen thousand) invalid names.
>
> The add-in took about 5 minutes just to display the list.
>
> Cheers,
>
> "Dave Peterson" wrote:
>
> > 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
> >
> > hugehead wrote:
> > >
> > > I have inherited an excel file filled to the brim with obsolete name
> > > definitions, numbering in the hundreds.
> > >
> > > I would like a macro that loops through these names, see where they refer
> > > to, and if they refer to any #REF!, or a particular external file that no
> > > longer exist, to delete the name itself.
> > >
> > > Any help would be appreciated.
> > > Thanks
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson