View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wigs wigs is offline
external usenet poster
 
Posts: 1
Default 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?