Delete #REF named ranges

Macro to Delete #REF range names

This macro will enable you to delete named ranges with #REF error in it.

Sub DeleteRefErrRanges()

'Macro Purpose: To delete any named range with a "#REF!" error in it

Dim nm As Name

For Each nm In ActiveWorkbook.Names

If InStr(1, nm.RefersTo, "#REF!") > 0 Then nm.Delete

Next nm

End Sub