I want to set my print area based on a formula. For example

if the value in cell I1 = 1

then print range A1:G23

otherwise print range H24:M44



I have found that you can type a statement like this:

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

into the print area box on the page setup tab and if I1=1 then excel
will replace =if(I1=1,A1:G23,H24:M44) with A1:G23

therefore printing what I wanted but lossing the formula.

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