Page Break Object and the HPage Breaks Collection

The HPageBreaks collection contains all of the horizontal page breaks in the printable area of the parent object. Each HPageBreak object represents a single horizontal page break for the printable area of the parent object. Possible parents of the HPageBreaks collection are the WorkSheet, Worksheets, and Chart objects.

The HPageBreaks collection contains one method besides the typical collection attributes. The Add method is used to add an HPageBreak object to the collection (and horizontal page break to the sheet). The Add method has a Before parameter to specify the range above where the horizontal page break will be added.

0 0

Post a comment