You need to use the INDIRECT worksheet function. For example, to refer to
cell A1 no matter what is inserted above or to the left of the current cell
A1:

=INDIRECT("A1")

HTH,
Bernie
MS Excel MVP

"knemitz" wrote in message
...
How do I keep a cell reference in a formula from changing when a cell is
inserted above it?