Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges - Created by system?
Hi All,
I have some named ranges that appear (using Karl Patriese's Name Manager) that l have not created. An example is: List_Estab!Extract =List_Estab!$AG:$AG the strange thing is that all of named ranges that l have not created myself have the suffix 'Extract' 1) Are these system generated named ranges? (KP's Name Manager tells me they are not) 2) What causes them to be generated? 3) Using KP's name manager l am told that they are not used in any formula's (apart from testing INDIRECT function, which l have not used) so can l delete them? This was highlighted when l was trying to reduce the workbook size and noticed that l hade a named ranged containing cells. All information gratefully received Regards Michael Beckinsale |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges - Created by system?
Excel creates its own names.
Extract can be created by running data|Filter|advanced filter (and extracting that list to a new range). Michael Beckinsale wrote: Hi All, I have some named ranges that appear (using Karl Patriese's Name Manager) that l have not created. An example is: List_Estab!Extract =List_Estab!$AG:$AG the strange thing is that all of named ranges that l have not created myself have the suffix 'Extract' 1) Are these system generated named ranges? (KP's Name Manager tells me they are not) 2) What causes them to be generated? 3) Using KP's name manager l am told that they are not used in any formula's (apart from testing INDIRECT function, which l have not used) so can l delete them? This was highlighted when l was trying to reduce the workbook size and noticed that l hade a named ranged containing cells. All information gratefully received Regards Michael Beckinsale -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges - Created by system?
Dave,
Thanks for that. It points me in the right direction as l have some VBA code that does exactly that. "Dave Peterson" wrote in message ... Excel creates its own names. Extract can be created by running data|Filter|advanced filter (and extracting that list to a new range). Michael Beckinsale wrote: Hi All, I have some named ranges that appear (using Karl Patriese's Name Manager) that l have not created. An example is: List_Estab!Extract =List_Estab!$AG:$AG the strange thing is that all of named ranges that l have not created myself have the suffix 'Extract' 1) Are these system generated named ranges? (KP's Name Manager tells me they are not) 2) What causes them to be generated? 3) Using KP's name manager l am told that they are not used in any formula's (apart from testing INDIRECT function, which l have not used) so can l delete them? This was highlighted when l was trying to reduce the workbook size and noticed that l hade a named ranged containing cells. All information gratefully received Regards Michael Beckinsale -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Named ranges | Excel Programming | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
New Named Range Created Each Time Data Imported into Excel via Macro | Excel Programming | |||
named ranges - changing ranges with month selected | Excel Programming | |||
Named ranges | Excel Programming |