View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
uno@korsmaa uno@korsmaa is offline
external usenet poster
 
Posts: 9
Default Delete names in workbook

.... 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