You could probably delete them manually by the time you developed the code to
do it. InsertNamedefine will bring up the listbox that has all of your
named ranges/cells so you can just pick the ones you want to delete and click
delete.

"greg" wrote:

I create and delete lots of cells in one of my excel applications. Each
cell has a named cell.
I have just noticed that I have a bunch of "bad"/"unreferenced" named cells.
I have a bunch of these
=Sheet1!#REF!

Is there a way I can go in and revove all of these programmatically?
Can you find named cells by REF?
thanks