HPageBreaks Collection Object [Excel 2003 VBA Language Reference]
The collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object.
Using the HPageBreaks Collection
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.
Note There is a limit of 1026 horizontal page breaks per sheet.
Methods | Add Method