HPageBreak Object

Microsoft Excel Visual Basic

previous page next page
Multiple objectsHPageBreaks
HPageBreak
Multiple objects

Represents a horizontal page break. The HPageBreak object is a member of the HPageBreaks collection.

Using the HPageBreak Object

Use HPageBreaks(index), where index is the index number of the page break, to return an HPageBreak object. The following example changes the location of horizontal page break one.

Worksheets(1).HPageBreaks(1).Location = Worksheets(1).Range("e5")

Note  There is a limit of 1026 horizontal page breaks per sheet.

previous page start next page