View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Batch deleting invalid defined names from a workbook

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