I am using the below code to clear from Name manager. Seemed to work fine last week now I am getting Run Time Error
Dim n As Name
For Each n In Names
Run time error 1004
The name that you entered is not valid.
Reasons for this can include:
-The name does not begin with a letter or an underscore
-The name contains a space or other invalid characters
-The name conflicts with an Excel built-in name or the name of another object in the workbook.
Please assist to resolve