VPageBreak Object

Microsoft Excel Visual Basic

previous page next page
Multiple objectsVPageBreaks
VPageBreak
Multiple objects

Represents a vertical page break. The VPageBreak object is a member of the VPageBreaks collection.

Using the VPageBreak Object

Use VPageBreaks(index), where index is the page break index number of the page break, to return a VPageBreak object. The following example changes the location of vertical page break one.

Worksheets(1).VPageBreaks(1).Location = Worksheets(1).Range("e5")
previous page start next page