How to use VBA to set up equal number of Rows per Page for a worksheet for print

[peter8848]

Hi,

I have a worksheet to print but sometimes excel print the last page with only one line, is it something can be defined to print equal number of the rows per page in order to combine the last page with one line into the 2nd last page but it will be good to have equal number of the rows per page when printing out.

Cheers,

Peter

[jolivanes]

cross post
https://www.mrexcel.com/forum/excel-questions/1073349-how-use-vba-set-up-equal-number-rows-per-page-worksheet-printing.html