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 Else cPartial = cPartial + 1 End If Next 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.