View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Delete names in workbook

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