Hi I have some code that sets a manual page break when my workbook opens but I need it to insert more than ONE fixed page break in ROWS 69 ROWS 93 and ROWS 120
I need this as I have an auto filter that changes the number of rows on the sheet and the Page Break keep adjusting..... So I need to lock them down.
Private Sub Workbook_Open()
Worksheets("Training Due").Rows(69).PageBreak = xlPageBreakManual
Worksheets("Training Due").Rows(93).PageBreak = xlPageBreakManual
End Sub
I get a DEBUG error when I try and apply 2 or more manual page breaks
Any ideas
Thanks
Bookmarks