What Excel 4.0 macro command do I need to use to delete a range na
 

I do not want to have to re-write my whole macro into VB if there is an Excel
4.0 command that will delete range names.

What Excel 4.0 macro command do I need to use to delete a range na
 

for each nm in ActiveWorkbook.Names
nm.Delete
Next

should do it.

--
Regards,
Tom Ogilvy


"Bobby@HSBC" wrote in message
...
I do not want to have to re-write my whole macro into VB if there is an
Excel
4.0 command that will delete range names.

What Excel 4.0 macro command do I need to use to delete a range na
 

The XL4 macro is: =DELETE.NAME(name_text)

--
Jim Rech
Excel MVP
"Bobby@HSBC" wrote in message
...
|I do not want to have to re-write my whole macro into VB if there is an
Excel
| 4.0 command that will delete range names.
|

What Excel 4.0 macro command do I need to use to delete a range na
 

I read your question several times and guess I still didn't understand what
you were asking for. Thanks to Jim Rech for giving the correct answer.
Sorry for the confusion.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
for each nm in ActiveWorkbook.Names
nm.Delete
Next

should do it.

--
Regards,
Tom Ogilvy


"Bobby@HSBC" wrote in message
...
I do not want to have to re-write my whole macro into VB if there is an
Excel
4.0 command that will delete range names.