Batch deleting invalid defined names from a workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hugehead - 13 Sep 2007 16:02 GMT

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

Reply to this Message

Dave Peterson - 13 Sep 2007 16:24 GMT

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

> I have inherited an excel file filled to the brim with obsolete name
> definitions, numbering in the hundreds.
[quoted text clipped - 5 lines]
> Any help would be appreciated.
> Thanks

Signature

Dave Peterson

Reply to this Message

hugehead - 20 Sep 2007 17:20 GMT

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,

> Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
> Manager:
[quoted text clipped - 11 lines]
> > Any help would be appreciated.
> > Thanks

Reply to this Message

Dave Peterson - 20 Sep 2007 17:59 GMT

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

> Thanks, I used it and believe it or not, the excel file had approximately
> 18,000 (eighteen thousand) invalid names.
[quoted text clipped - 22 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message