Delete names in workbook

[U. Kõrsmaa]

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

 

[Pete McCosh]

Not with one command, but

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

Should do it.

Pete

 

[Bob Phillips]

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)

 

[Tom Ogilvy]

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

 

[uno@korsmaa]

thanks a lot

Not with one command, but

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

Should do it.

Pete

 

[uno@korsmaa]

Thank you very much

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)

 

[uno@korsmaa]

.... and thank you very much too

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