Sheets.HPageBreaks Property

Syntax

expression.HPageBreaks

expression A variable that represents a Sheets object.

Remarks
There is a limit of 1026 horizontal page breaks per sheet.

Example

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"

See also:

• Sheets Object
• Sheets Object Members