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
<steve_nelson@discussions.microsoft.com> 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:@MSITStore:C:\Program%20Files\Microsoft%20Office\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" <steve_nelson@discussions.microsoft.com> wrote in message
news:31503776-7B89-4ED2-898F-63D1DA62188A@microsoft.com...
| How do I delete names (name ranges) all at once, rather then having to do
it
| individually