Instead of using say =A19, use =OFFSET(A20,-1,0). This would go in A20, and
as it doesn't explicitly refer to A19, it doesn't fail when row 19 is
deleted.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stuhag" wrote in message
...
Hi
I have a kin a formula wich gets the value from the cell above and then
add
some.
What I get is an list of values incrementing.

When I delete one row in this list, all cells below 'crashes' with #REF!.
What I need is that for the formulas to always look one cell up, even if I
delete a row. Now it seems that if I delete Row8, then when Row9 become
Row8
it reference to it self and then ov course goes bananas...

Hope I made myself understandable ;-)

Any ideas folks?

--------
stuhag
---------