HPageBreaks Collection Object

         Properties         Methods        

Sheets collection
HPageBreaks collection (HPageBreak object)

The collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object.

Using the HPageBreaks Collection

Use the HPageBreaks property to return the HPageBreaks collection. Use the Add method to add a horizontal page break. The following example adds a horizontal page break above the active cell.

ActiveSheet.HPageBreaks.Add Before:=ActiveCell

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.