Then your formulas need to be written as, for example =$B3
Using an "absolute reference" like this keeps the "B" from changing to "C"
if you insert a column.
************
Anne Troy
www.OfficeArticles.com
"George" wrote in message
...
Simple example:
C3 = B3+1
Insert a new column C; old col C changes to ..
D3 = B3+1 (where col D was col C)
A similar thing occurs if I copy col C, and 'insert copied cells' at
col C. Then, I get ...
C3 = A3+1
D3 = B3+1
What I'd like is to maintain the relative offset ..
C3 = B3+1
D3 = C3+1
Thanks,
George