| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete Ranges via macro
hi
i need to delete all the ranges that related to spesific sheet. how should i do that? i also need to copy all the ranges that related to spesific sheet to another. how do i do that? i found the way to delete it according to the name.... it is not good enough for my needs... ActiveWorkbook.Names("vvv").Delete -- Miri Tz. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete Ranges via macro
Turn on the macro recorder and do it manually. Review the recorded code to
see how it is possible. -- Regards, Nigel "Miri" wrote in message ... hi i need to delete all the ranges that related to spesific sheet. how should i do that? i also need to copy all the ranges that related to spesific sheet to another. how do i do that? i found the way to delete it according to the name.... it is not good enough for my needs... ActiveWorkbook.Names("vvv").Delete -- Miri Tz. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete unnecessary Named Ranges | Excel Discussion (Misc queries) | |||
| Can't delete named ranges? | Excel Programming | |||
| Delete all named ranges in a workbook | Excel Programming | |||
| macro to delete all named ranges in a workbook en masse? | Excel Discussion (Misc queries) | |||
| Delete LOCAL named ranges | Excel Programming | |||
Hybrid Mode
