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"