HPageBreak HPageBreak HPageBreak Interface


Represents a horizontal page break.

public interface class HPageBreak
public interface HPageBreak
Public Interface HPageBreak


The HPageBreak object is a member of the HPageBreaks collection.

Use HPageBreaks(index), where index is the index number of the page break, to return an HPageBreak object.

Note There is a limit of 1,026 horizontal page breaks per sheet.


Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Creator Creator Creator

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

Extent Extent Extent

Returns the type of the specified page break: full-screen or only within a print area.

Location Location Location

Returns or sets the cell (a Range object) that defines the page-break location.

Parent Parent Parent

Returns the parent object for the specified object.

Type Type Type

Returns or sets the page break type.


Delete() Delete() Delete()

Deletes the object.

DragOff(XlDirection, Int32) DragOff(XlDirection, Int32) DragOff(XlDirection, Int32)

Drags a page break out of the print area.

Applies to