HPageBreaks Object (Excel)
Published: July 16, 2012
The collection of horizontal page breaks within the print area.
Each horizontal page break is represented by an HPageBreak object.
If you add a page break that does not intersect the print area, then the newly-added HPageBreak object will not appear in the HPageBreaks collection for the print area. The contents of the collection may change if the print area is resized or redefined.
For an automatic print area, the HPageBreaks property applies only to the page breaks within the print area.
For a user-defined print area of the same range, the HPageBreaks property applies to all of the page breaks.
There is a limit of 1026 horizontal page breaks per sheet.