Multiple objects VPageBreaks VPageBreak Multiple objects |
A collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.
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.
When the Application property, Count property, Creator property, Item property, Parent property or Add method is used in conjunction with the VPageBreaks property: