Deleting Names in Excel 2003

[Guest]

How do I delete names (name ranges) all at once, rather then having to do it
individually

 

[Michael Bednarek]

How do I delete names (name ranges) all at once, rather then having to do it
individually

With VBA:

Dim myName As Name

For Each myName In Names
myName.Delete
Next myName

Qualify Name as required: Application, Workbook, Worksheet. Unqualified,
Names will refer to ActiveWorkbook. See Help: Names Property
(<mkMSITStore:C:\Program%20Files\Microsoft%20Office\OFFICE11\1033\VBAXL10.CHM::/html/xlproNames1.htm>).

 

[Jim Rech]

To do what you want and many other things with names you should get this
free Names Manager utility:

http://www.jkp-ads.com/Download.htm#NameManager

--
Jim Rech
Excel MVP
| How do I delete names (name ranges) all at once, rather then having to do
it
| individually