Dear masters

I tried several ways but could not find a solution.

How can I delete all the range names in the workbook with one command?

Thanks in advance
U.Kõrsmaa

Not with one command, but

For Each n in Activeworkbook.names
N.delete
Next N

Should do it.

Pete
-----Original Message-----
Dear masters

I tried several ways but could not find a solution.

How can I delete all the range names in the workbook with
one command?

Thanks in advance
U.Kõrsmaa


.

Here you go

Dim nme As Name

For Each nme In ActiveWorkbook.Names
Debug.Print nme.Name
nme.Delete
Next nme


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"U. Kõrsmaa" wrote in message
...
Dear masters

I tried several ways but could not find a solution.

How can I delete all the range names in the workbook with one command?

Thanks in advance
U.Kõrsmaa

Lotus had that option:

There's a quick keyboard method based on Lotus 1-2-3

/rnr

/ Range Name Reset

It's a powerful command not replicated by Excel

but you can easily loop through names

for each nm in thisworkbook.name
nm.delete
Next

--
Regards,
Tom Ogilvy


"U. Kõrsmaa" wrote in message
...
Dear masters

I tried several ways but could not find a solution.

How can I delete all the range names in the workbook with one command?

Thanks in advance
U.Kõrsmaa

thanks a lot

"Pete McCosh" wrote in message
...
Not with one command, but

For Each n in Activeworkbook.names
N.delete
Next N

Should do it.

Pete
-----Original Message-----
Dear masters

I tried several ways but could not find a solution.

How can I delete all the range names in the workbook with
one command?

Thanks in advance
U.Kõrsmaa


.

Thank you very much

"Bob Phillips" wrote in message
...
Here you go

Dim nme As Name

For Each nme In ActiveWorkbook.Names
Debug.Print nme.Name
nme.Delete
Next nme


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"U. Kõrsmaa" wrote in message
...
Dear masters

I tried several ways but could not find a solution.

How can I delete all the range names in the workbook with one command?

Thanks in advance
U.Kõrsmaa

.... and thank you very much too

"Tom Ogilvy" wrote in message
...
Lotus had that option:

There's a quick keyboard method based on Lotus 1-2-3

/rnr

/ Range Name Reset

It's a powerful command not replicated by Excel

but you can easily loop through names

for each nm in thisworkbook.name
nm.delete
Next

--
Regards,
Tom Ogilvy


"U. Kõrsmaa" wrote in message
...
Dear masters

I tried several ways but could not find a solution.

How can I delete all the range names in the workbook with one command?

Thanks in advance
U.Kõrsmaa