how to delete "NOT VALID" range names by vba

Originally Posted by Whizbang

I just updated my most recent code sample. I realized there was a potential that it could try to delete the same named range twice (if the named range referenced another workbook, but also had #REF in the address). So, I changed it to an Elseif scenario.

Thanks again so much.

however my real problem is not so much to choose which range names to delete or not (would be happy to delete them all!), but rather than when the macro gets to the line rgnm.delete produces an error. also sometimes there are a number of hidden rangenames that do not appear even if I go through all range names and set rgnm.visible = true

still the problem is small enough (sort of) for the good old contingency plan of doing it by hand!


regards,

Bernat