VPageBreaks Collection Object

         Properties         Methods        

Sheets collection
VPageBreaks collection (VPageBreak object)

A collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.

Using the VPageBreaks Collection

Use the VPageBreaks property to return the VPageBreaks collection. Use the Add method to add a vertical page break. The following example adds a vertical page break to the left of the active cell.

ActiveSheet.VPageBreaks.Add Before:=ActiveCell

If you add a page break that does not intersect the print area, then the newly-added VPageBreak object will not appear in the VPageBreaks collection for the print area. The contents of the collection may change if the print area is resized or redefined.