A cell reference in a formula changing

[knemitz]

How do I keep a cell reference in a formula from changing when a cell is
inserted above it?

[Bernie Deitrick]

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" <[email protected]> wrote in message
news:[email protected]...
> How do I keep a cell reference in a formula from changing when a cell is
> inserted above it?