Delete names in workbook
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 |
Delete names in workbook
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 . |
Delete names in workbook
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) "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 |
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 |
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 . |
Delete names in workbook
Thank you very much
"Bob Phillips" wrote in message ... 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) "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 |
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 |
All times are GMT +1. The time now is 11:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com