Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert changes Named references
When I insert a column with VBA, it shifts all of the range references in
the Names for all columns after the inserted one. Example; Before insert Column: One Two Three Four Name: A B C D After Insert Column: One Two New Three Four Name: A B C D It's as if the Name RefersTo property isn't updated when the insert happens. Anyone haev data on this and how to correct or work around it? Thanks, Patrick Heilman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
references to named cells | Excel Discussion (Misc queries) | |||
Named Cell References in VBA | Excel Discussion (Misc queries) | |||
Named References | Excel Discussion (Misc queries) | |||
Using named cells in relative references | Excel Programming | |||
Using Named Cell References that aren't present yet. | Excel Programming |