You could use INDIRECT, eg:
=SUM(INDIRECT("'Sheet1'!A1:A1000"))
will always point to A1:A1000 in Sheet1
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"jlclyde" wrote in message
...
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