| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. | |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete blank rows in a data range | Excel Discussion (Misc queries) | |||
| delete rows in range - macro | Excel Worksheet Functions | |||
| Macro to copy, paste in a range and then delete | Excel Discussion (Misc queries) | |||
| Need macro to delete all text cells in an Excel range | Excel Worksheet Functions | |||
| Selecting an Excel tab, Delete Worksheet command is not active | New Users to Excel | |||
Linear Mode
