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