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

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


.