This documentation is archived and is not being maintained.

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

Public Class pageBreaksImplementation
	Implements HPageBreaks
End Class
Dim pageBreaksImplementation1 As New pageBreaksImplementation()

public interface HPageBreaks
public interface HPageBreaks
public interface HPageBreaks

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.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms