Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |