Insertng Manual page breaks in set Rows

[hans302]

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.

Please Login or Register  to view this content.

I get a DEBUG error when I try and apply 2 or more manual page breaks

Any ideas

Thanks

[tony h]

What is the debug error?

PS the code works for me (I used sheet1)