Delete names in workbook

  • Thread starter Thread starter U. Kõrsmaa
  • Start date Start date
U

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
 
Not with one command, but

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

Should do it.

Pete
 
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)
 
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
 
thanks a lot

Not with one command, but

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

Should do it.

Pete
 
Thank you very much

Bob Phillips said:
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)
Click to expand...
 
.... and thank you very much too

Tom Ogilvy said:
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
Click to expand...
 
Back
Top