HPageBreaks interface

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

public interface HPageBreaks : IEnumerable

Use the HPageBreaks property to return the HPageBreaks collection. Use the Add method to add a horizontal page break.

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.

When the Application property, Count property, Creator property, Item property, Parent property, or Add method is used in conjunction with the HPageBreaks property:

  • 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 1,026 horizontal page breaks per sheet.