Thread: Keep Same Range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
 
Posts: 117
Default Keep Same Range

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