Hi,
I have this code that sets the print area. Is there a way to amend slightly so it says that each page should have 59 rows from the excel spreadsheet? This is because it is putting page breaks in weird places, and not just sticking to the page setup format, from the looks of it.
Ta,
Mark
I have this code that sets the print area. Is there a way to amend slightly so it says that each page should have 59 rows from the excel spreadsheet? This is because it is putting page breaks in weird places, and not just sticking to the page setup format, from the looks of it.
Ta,
Mark
Code:
Sub PrintArea()
bottom = ActiveSheet.Range("N65536").End(xlUp).Row
Cells.Select
ActiveSheet.PageSetup.PrintArea = ""
Range("A1").Select
MyRange = ("I1" & ":" & "O" & bottom)
ActiveSheet.PageSetup.PrintArea = MyRange
End Sub