Find and delete unused Defined Name References

[mjones]

Hi All,

After pasting several worksheets together, I find an overwhelming
number of defined names came from one of them. Is there a way to
determine if any names are not used so I can delete them? I'm
guessing not, but there are so many wizards in the group, I thought to
ask anyway.

Thanks!

Michele

 

[Gord Dibben]

Download Jan Karel Pieterse's Name Manager add-in and filter for unused names.

http://www.oaltd.co.uk/MVP/Default.htm

Click on Jan's name on list of MVPs


Gord Dibben MS Excel MVP