HPageBreaks Collection Object

Description

The collection of horizontal page breaks. 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

Properties

Application property, Count property, Creator property, Item property (HPageBreaks collection), Parent property.

Methods

Add method (HPageBreaks collection).