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]

Hello,

Just turn on your macro recorder ...

Once you have go through your process ... you will get a macro where you can insert all the variables you need ...

Hope this will help

 

[MARK858]

Are you in reality just trying to set the print to the last row in column E each time?

 

[komobu]

Are you in reality just trying to set the print to the last row in column E each time?

No...I have notes and tax data on the page starting at row 100, and that stuff I dont want printed.

 

[komobu]

Hello,

Just turn on your macro recorder ...

Once you have go through your process ... you will get a macro where you can insert all the variables you need ...


Hope this will help

Thanks james, but the sheet will be used by someone else. I was hoping to avoid macros if possible. I really have to make this sheet to be able to be used by people that dont know excel.

 

[MARK858]

No...I have notes and tax data on the page starting at row 100, and that stuff I dont want printed.

Is the next row after the row in column E that you want printed blank? is column F blank? and are there any blank rows or columns within the print area?

I was hoping to avoid macros if possible.

You won't be able to set the print area without using a macro or manually setting it each time. You can't do it with a formula. You can get the macro to run automatically when the sheet is activated, the workbook opened etc. but the user will still have to enable macro's.

 

[Eric W]

You can set the print area with a formula. The print area is in fact a named range. If you create a named range with the Name Manager called Print_Area, and use an OFFSET formula to define the desired range, then the print area will adjust. See here:

https://pakaccountants.com/excel-dynamic-print-area-how-to/

 

[MARK858]

Thanks Eric, learnt something new today

 

[komobu]

Thanks Eric...That link worked great!

 

[Eric W]

Great, glad we could help!

Mark, someday I hope to learn everything about Excel! I'm pretty sure that day will never come, but I'll keep working at it.