Page break or Fit to Page Macro
 

I have a sheet that automatically sets the print area based on values in
column R. However, I end up with only 2 rows of data printing on the last
page.
Option 1 - Is there a way to automatically set the page breaks so there is
approximately the sames rows per page?
or
option 2 - Is there a way to set a variable "fit to page" value based on the
number of rows?