HPageBreaks HPageBreaks HPageBreaks Interface


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

public interface class HPageBreaks : System::Collections::IEnumerable
public interface HPageBreaks : System.Collections.IEnumerable
Public Interface HPageBreaks
Implements IEnumerable


Use the HPageBreaks property to return the HPageBreaks collection. Use the Add(Object) 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[Int32] property, Parent property, or Add(Object) 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.


_Default[Int32] _Default[Int32] _Default[Int32]

Reserved for internal use.

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Count Count Count

Returns the number of objects in the collection.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Item[Int32] Item[Int32] Item[Int32]

Returns a single object from a collection.

Parent Parent Parent

Returns the parent object for the specified object.


Add(Object) Add(Object) Add(Object)

Adds a horizontal page break. Returns an HPageBreak object.

GetEnumerator() GetEnumerator() GetEnumerator()

Applies to