Set Page Breaks to 36 rows and find last row in column J

[Ravenous]

Hi All,

I am having trouble with getting this code to work properly, not sure how to fix it.

I need to do 2 things on a Sheet that will constantly have a changing amount of rows so that the printable area is as follows:

1. set the Page Breaks to 36 rows
2. set the bottom of the print area to the last row of data for range A:L based on the lowest row of data in column J.

This is my code, what am I doing wrong?

Please Login or Register  to view this content.

Thanks,
Brendan

[protonLeah]

You didn't describe the problem, however:

Please Login or Register  to view this content.

[Ravenous]

Thanks for your reply! Your code works (I have adjusted it slightly as per below) except I am getting a small page that doesn't adhere to the rule as per below image.

Capture.PNG

Please see attached example workbook.

Please Login or Register  to view this content.

[bakerman2]

How about this.

Please Login or Register  to view this content.

[Ravenous]

Perfect! Thanks bakerman2

[bakerman2]

Ben did all the hard work but glad to help anyway.
Thanks for rep+.