| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you delet all the defined range names in a excel file
I working with a file that has around 400 defined ranges and I would like to
know if there is a vba command that delete all the ranges quiclkly Thanks -- Helping Is always a good thing |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you delet all the defined range names in a excel file
Hi
consider Dim n As Name For Each n In ThisWorkbook.Names n.Delete Next -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "QuietMan" wrote: I working with a file that has around 400 defined ranges and I would like to know if there is a vba command that delete all the ranges quiclkly Thanks -- Helping Is always a good thing |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do you delet all the defined range names in a excel file
Thanks,
-- Helping Is always a good thing "Wigi" wrote: Hi consider Dim n As Name For Each n In ThisWorkbook.Names n.Delete Next -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "QuietMan" wrote: I working with a file that has around 400 defined ranges and I would like to know if there is a vba command that delete all the ranges quiclkly Thanks -- Helping Is always a good thing |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Defined Range Names in formulas | Excel Discussion (Misc queries) | |||
| save worksheet as another file, but have all defined names copied | Excel Discussion (Misc queries) | |||
| Defining a range using defined names | Excel Programming | |||
| Rename Several Defined Range Names with Macro | Excel Programming | |||
| Listing or Changing all Defined Range Names (using VBA) | Excel Programming | |||
Hybrid Mode
