Thanks, Tom - works fine...
-----Original Message-----
=Indirect("C3")

--
Regards,
Tom Ogilvy

"Phil Hageman"
wrote in message
...

Case One Case Two
A B C D A B C D
1 =C1 3 1 =C1 5 3

In Case One, the value for B1 is 3. When a new column C
is inserted (Case Two), the formula in B1 is
automatically
changed to =D1, and the value remains 3. Is there a way
to write the formula so it retains the intent of =C1
after
the new column is inserted - such that the value in B1
would now equal 5?
=$C$1 doesn't work - it too changes to =$D$1.
Thanks,
Phil


.