Sheets.HPageBreaks property (Excel)
Returns an HPageBreaks collection that represents the horizontal page breaks on the sheet. Read-only.
expression A variable that represents a Sheets object.
There is a limit of 1026 horizontal page breaks per sheet.
This example displays the number of full-screen and print-area horizontal page breaks.
For Each pb in Worksheets(1).HPageBreaks If pb.Extent = xlPageBreakFull Then cFull = cFull + 1 Else cPartial = cPartial + 1 End If Next MsgBox cFull & " full-screen page breaks, " & cPartial & _ " print-area page breaks"
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.