Cell ranges

[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 D452.
However, when I insert a row at row 4 every month, the workshee
automatically change the formula to cells B5:B53 and D553.

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

Thanks

 

[Bob Phillips]

Look at using INDIRECT, such as

=INDIRECT("Sheet1!B4")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)