N
Nodak
I am trying to delete all Named Ranges Except "Print_Area" is there a way to
accomplish this? the code below deletes "Print_Area"..
Sub DeleteNames()
Dim ThisName As Name
For Each ThisName In ActiveWorkbook.Names
If ThisName <> "Print_Area" Then ThisName.Delete
Next ThisName
End Sub
accomplish this? the code below deletes "Print_Area"..
Sub DeleteNames()
Dim ThisName As Name
For Each ThisName In ActiveWorkbook.Names
If ThisName <> "Print_Area" Then ThisName.Delete
Next ThisName
End Sub