Hi!
With the help of the VBA code, I created several named ranges. The name consists of the word "Range" and the line number in which the range begins (eg "Range1", "Range44", "Range205", without ").
I can delete all of these ranges manually in the Names Manager.
However, I have trouble deleting these ranges using the VBA code belove
Sub DeleteNames()
'Update 20140314
Dim xName As Name
For Each xName In Application.ActiveWorkbook.Names
    xName.Delete
Next
End Sub
It gives me Run-time error 1004: The syntax of this name isn't correct.
d65c0210-cd74-4feb-87a0-6f91f03f8282.png

I would appreciate any advise on how to resolve this. I'm using excel 365.

Frank