Setting a Dynamic Print Area on a template.xlsx

[scaffdog845]

Morning all,

Attached is a formatted workbook that is used as part of a weekly scheduling process. I am looking for a way to set a dynamic print area for the "3 week schedule by order" worksheet.

Right now the print area is set to

Please Login or Register  to view this content.

whis is usually larger than the data being pasted into it.

Once SAP data is queried and entered into the sheet the total number of rows containing data will not be equal to 686. For this example there is a Desired Results worksheet containing only 330 rows of data.

The last row containing data in A:A will always be the last row of the print area, and the end of the print area will always be N:N of that row.

How can this be automated?

As always.... Thanks for the help.

[scaffdog845]

I think I figured it out. I was thinking it may be a VBA solution however a formula for the print area seems to do the trick.

Please Login or Register  to view this content.

Lifes great when you get it yourself.