VPageBreak Object

Microsoft Excel Visual Basic

previous page next page

VPageBreak Object

         
Sheets VPageBreaks (VPageBreak)

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