Share via

HPageBreak Object

  • Article
Excel Developer Reference

Represents a horizontal page break.

Remarks

The HPageBreak object is a member of the HPageBreaks collection.

Bb223858.vs_note(en-us,office.12).gif  Note
There is a limit of 1026 horizontal page breaks per sheet.

Example

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.

Visual Basic for Applications 
  Worksheets(1).HPageBreaks(1).Location = Worksheets(1).Range("e5")

See Also