Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / September 2007

Tip: Looking for answers? Try searching our database.

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
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

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
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.