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