Im not sure what you mean when you say "in the refers to box:". If you
mean the print area box on the sheet tab of page setup from the file
menu then your formula:

"=INDIRECT(IF('Sheet1'!$I$1=1,"$A$1:$G$23","$H$24: $ M$44"))"

works similar to my formula:

"=if(I1=1,A1:G23,H24:M44)".

Lets say that cell A1 = 1.
If you enter my formula or your formula into the Print area box, click
ok, close the page setup window, and reopen the page setup window the
Print are box will read A1:G23. Which is the area I wanted to print.
The problem arrises when say cell A1 changes from 1 to some other
value. The print area will not change because the formula is no longer
there. any ideas.


--
kwrohde
------------------------------------------------------------------------
kwrohde's Profile: http://www.excelforum.com/member.php...fo&userid=5721
View this thread: http://www.excelforum.com/showthread...hreadid=535671