I have a sheet with several rows which, during the normal use of the sheet, may get expanded height-wise, basically meaning the sheet may get longer when a use fill it out. I'm trying to figure out how to set up a macro to make the sheet print in a best-fit sort of manner, and that would run at print-time.
To explain a little further, the sheet right now has a bunch of page breaks which I guess were automatic Excel breaks. So, if a user fills in very little information, then some of the pages will have just a few lines, and the rest blank.
There was a discussion on this here , but I'm curious if there's a way to make a macro just insert a page break every 'x' number of pixels, rounding to the nearest full row, until it reaches the end of the sheet.