Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Names
I need a simple way to delete all range names from a source file that I
process. I have no control over the source file. The file has a bajillion defined names that I'd like to not even know what they are, just delete all. Must I do them individually, or.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Names
Sub DelAllNames()
Dim nm As Name For Each nm In ActiveWorkbook.Names nm.Delete Next End Sub Regards, Peter T "Glenn" wrote in message ... I need a simple way to delete all range names from a source file that I process. I have no control over the source file. The file has a bajillion defined names that I'd like to not even know what they are, just delete all. Must I do them individually, or.... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Names
Sub DeleteNames() Dim nme As Name For Each nme In ActiveWorkbook.Names If nme.Name Like "*_FilterDatabase" Or _ nme.Name Like "*Print_Area" Or _ nme.Name Like "*Print_Titles" Or _ nme.Name Like "*wvu.*" Or _ nme.Name Like "*wrn.*" Or _ nme.Name Like "*!Criteria" Then Else nme.Delete End If Next nme End Sub -- __________________________________ HTH Bob "Glenn" wrote in message ... I need a simple way to delete all range names from a source file that I process. I have no control over the source file. The file has a bajillion defined names that I'd like to not even know what they are, just delete all. Must I do them individually, or.... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Names
In addition to the other postings you got, you might want to consider that
some (if not all) of those names are used in worksheet formulas... if that is the case and you delete them, you will break every one of those formulas. -- Rick (MVP - Excel) "Glenn" wrote in message ... I need a simple way to delete all range names from a source file that I process. I have no control over the source file. The file has a bajillion defined names that I'd like to not even know what they are, just delete all. Must I do them individually, or.... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Names
I'd get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew
Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp Glenn wrote: I need a simple way to delete all range names from a source file that I process. I have no control over the source file. The file has a bajillion defined names that I'd like to not even know what they are, just delete all. Must I do them individually, or.... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
Create range names with names in column heading | Excel Programming | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Is there a way to give range names (especially with relative reference) for series names and series values in Excel 2007 graphs? | Excel Programming | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) |