Cell ranges

  • Thread starter Thread starter ATK
  • Start date Start date
A

ATK

I have a workbook that I have to make additions to every month. Th
first three rows are headers and every month, I have to insert a row a
row 4.

On another worksheet, I have to work with the cells B4:B52 and D4:D52.
However, when I insert a row at row 4 every month, the workshee
automatically change the formula to cells B5:B53 and D5:D53.

Is there a way to work with B4:B52 and D4:D52 regardless of what row
are inserted??

Thanks
 
Look at using INDIRECT, such as

=INDIRECT("Sheet1!B4")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Back
Top