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