Deleting Names in Excel 2003
 

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

On Wed, 5 Jan 2005 19:25:06 -0800, steve_nelson
wrote in
microsoft.public.excel.misc:

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
(<mk:@MSITStoC:\Program%20Files\Microsoft%20Off ice\OFFICE11\1033\VBAXL10.CHM::/html/xlproNames1.htm).

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

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
"steve_nelson" wrote in message
...
| How do I delete names (name ranges) all at once, rather then having to do
it
| individually