Don't know if this helps, but

In cell B10 if you enter =OFFSET(B10,-2,3)
Then it will always refer to the cell 2 up and 3 to the right, regardless of
whether you insert or delete rows or columns between the referenced cell and
the referencing cell.


"Luc Benninger" wrote in message
...
Hi,
I should create a formula with kind of a static cell reference within.
That means, if cells are deleted or inserted above or to the left of the
referenced cell, the reference should still point to the same cell as
before and not be automatically adjusted. Is this possible??
Thanks, Luc