Programable Print Area?

[komobu]

Is it possible to adjust the print area program-ably?

I have a print area of say Cell A1 to Cell E50. This will do for 80% of my needs. Occasionally the table may extend another 15 rows or so. For this I would like to add a column F and use an "If" statement like If(E51 <>"", Set print area A1 to E51") then I could copy that statement down to E100 .

Is something like this possible?

Thanks for any help

 

[James006]

@ Eric W

Thanks for the Fun trick ... :wink: