John,

NameMaster is a fantastic tool for deleting the bloated names. http://www.decisionmodels.com/Downlo...Manager_32.zip

If you have a file that has been used for a while as the basis for generating new modules then running Name Manager can be quite an eye opener as to how much junk gets accumulated

As an aside, a sheet copy method, either manually or in VBA will replicate the names in the new book. This is normally useful as a copy and paste won't copy the names. But as per John's note the opposite effect is needed

Cheers

Dave