If you work with names, do yourself a favor and get a copy of Jan Karel
Pieterse's (with Charles Williams and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

akyhne wrote:
>
> How to delete broken named ranges in sheet?
>
> When you manually delete rows or columns than contains named ranges, the
> named ranges in the deleted area is not deleted, but remains with a faulty
> reference as (Example): MYNAMEDRANGE =SHEETS!#REFERENCE!

--

Dave Peterson