I think you'll find that deletion of rows will cause that formula to change,
Ronaldo.

If you want it not to change, replace reference to A1:A1000 by
INDIRECT("A1:A1000")
--
David Biddulph

"RonaldoOneNil" wrote in message
...
Use $A$1:$A$1000

"jlclyde" wrote:

I have a formula and the range in the formula is A1:A1000 and I want
this to stay A1:A1000 even if I delte rows. Is this possible? I
thought I read somethign someplace. Any help is appreciated.
Thanks,
Jay