Deleting rows without losing formulas
John,
Instead of a2=A1+1, A3=A2+1 etc
try a2=offset(a2,-1,0)+1, a3=offset(a3,-1,0)+1 etc
regards,
Lionel
"John Davies" wrote:
If I have a column of cells, say A1 to A15 with the values of A1=1,
A2=A1+1,A3=A2+1 etc, then if I want to delete say row A6, row A7 will show
the #REF! error. Is there a way to delete the row without losing the
formula in the next row?
|