View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stuhag
 
Posts: n/a
Default referencing the cell above

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
---------