I'm trying to set a workbook up so that all the sheets look the same size when printed out. Each sheet is different, with a different number of rows and columns in the print area, but I have a drawing object I'd like to use as a footer on the bottom of each page. I've made sure the page settings (margins, etc) are the same on each sheet and I've checked the size of the print area matches using
activesheet.range(activesheet.PageSetup.PrintArea).width & "x" & activesheet.range(activesheet.PageSetup.PrintArea).height
but when I view page breaks or print the workbook, pages 1 and 2 print out fine, but page 3 prints out on 2 pages with an extra page break at the bottom.
Adjusting some cell heights on page 3, reducing the total height of the print range by 5.25pts makes it fit, but I have no idea why!
Any thoughts?
