In short the answer is no. Deleting a row will modify all formulas that
referenced a range which contained that row as a part of it.
--
HTH...

Jim Thomlinson


"PeteJ" wrote:

I have a bunch of references to some data that I copy into a datasheet.
Occasionally, this data has some blank rows or rows with unneeded data in it.
If I delete those rows, it messes up all the formulas on other pages. Is
there a way to define the formulas such that deleting data won't change them?
I've tried using absolute cell references ($A$5), but when I delete the line,
this cell reference gets changed.

Thanks,

Pete