Hi

I have compiled a spreadsheet using a previous file I had created.

As the data compiled is vastly different than the last I have a huge drop down list within the 'Name Box' of previously named cells/ranges.

Is there a way to purge this list deleting redundant names without checking each ones integrity. (This list runs into hundreds, so will be a long process)

Will appreciate anyone's help

Regards

Steve