Worksheet.VPageBreaks property (Excel)

Returns a VPageBreaks collection that represents the vertical page breaks on the sheet. Read-only.



expression A variable that represents a Worksheet object.


This example displays the total number of full-screen and print-area vertical page breaks.

For Each pb in Worksheets(1).VPageBreaks 
 If pb.Extent = xlPageBreakFull Then 
 cFull = cFull + 1 
 cPartial = cPartial + 1 
 End If 
MsgBox cFull & " full-screen page breaks, " & cPartial & _ 
 " print-area page breaks"

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.