As Indirect is volatile I rarely use it and post it as a suggestion even
less. Indirect is a truely static reference and unless you want to write all
of your formulas individually or write very complicated formulas it's usage
is limited to little one off applications. Normally a properly organized
spreadsheet will not require it.

To each his own but I can count on one hand the number of times I have used
it in the past couple of years.
--
HTH...

Jim Thomlinson


"David Biddulph" wrote:

=INDIRECT("A5")
--
David Biddulph

"Jim Thomlinson" wrote in message
...
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


.