I have created a utility that contains named constants used for data validation on a particular sheet. As an enhancement requirement from the users, they want to be able to copy another workbooks sheet(s) into the utility. While using some sample files provided from the users, I have encountered name constants are being copied into the utility.

There is a routine that I can write to eliminate unneeded name constants, while keeping the required ones?

How can I get a listing of the named constants listed in the Define Name dialog box and only those names (not the Refers To€�) along with the associated index

Any assistance would be greatly appreciated