Cell ranges
 

I have a workbook that I have to make additions to every month. The
first three rows are headers and every month, I have to insert a row at
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 worksheet
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 rows
are inserted??

Thanks.


--
ATK
------------------------------------------------------------------------
ATK's Profile: http://www.excelforum.com/member.php...o&userid=27662
View this thread: http://www.excelforum.com/showthread...hreadid=505644

Cell ranges
 

Look at using INDIRECT, such as

=INDIRECT("Sheet1!B4")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"ATK" wrote in message
...

I have a workbook that I have to make additions to every month. The
first three rows are headers and every month, I have to insert a row at
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 worksheet
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 rows
are inserted??

Thanks.


--
ATK
------------------------------------------------------------------------
ATK's Profile:
http://www.excelforum.com/member.php...o&userid=27662
View this thread: http://www.excelforum.com/showthread...hreadid=505644