Edit

Share via

Worksheets.VPageBreaks property (Excel)

  • Article

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

Syntax

expression.VPageBreaks

expression A variable that represents a Worksheets object.

Example

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.