Set page breaks at specific rows?

I searched and was not successful solving this simple issue.

I want to set the horizontal page breaks at specific rows. I have rows hidden in the sheet, and would like to adjust the print area and the page breaks as the number of rows change.

For example:

break 1 = above row 50
break 2 = above row 160

Thank you for helping me.

Excel 2000

I have this code but it returns an error.

Please Login or Register  to view this content.

Hello proepert,

Is the worksheet protected?

Originally Posted by Leith Ross

Is the worksheet protected?

No it is not protected.

Sorry, I had this in the Private Sub Worksheet_Activate() section.

Is there a way to make the code work in the Private Sub Worksheet_Activate() section?

I get this error on the .Cells code: "Invalid or unqualified reference."

Hello proepert,

Try this...

Please Login or Register  to view this content.