Unused Named Cells

[beetlejuice1976]

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

[mrice]

This macro should do it.

Please Login or Register  to view this content.

I'm not sure what you meant be redundant. If you mean contains no data then use..

Please Login or Register  to view this content.