WorksheetBase.VPageBreaks Property

Gets a Microsoft.Office.Interop.Excel.VPageBreaks collection that represents the vertical page breaks on the sheet.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public ReadOnly Property VPageBreaks As VPageBreaks
    Get

public VPageBreaks VPageBreaks { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.VPageBreaks
A Microsoft.Office.Interop.Excel.VPageBreaks collection that represents the vertical page breaks on the sheet.

Examples

The following code example uses the VPageBreaks property to add a vertical page break at cell C5.

This example is for a document-level customization.

Private Sub InsertPageBreaks()
    Dim hbreak As Excel.HPageBreak = _
        Me.HPageBreaks.Add(Me.Range("C5"))
    Dim vbreak As Excel.VPageBreak = _
        Me.VPageBreaks.Add(Me.Range("C5"))
End Sub

private void InsertPageBreaks()
{
    Excel.HPageBreak hbreak =
        this.HPageBreaks.Add(this.Range["C5", missing]);
    Excel.VPageBreak vbreak =
        this.VPageBreaks.Add(this.Range["C5", missing]);
}

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

WorksheetBase Class

Microsoft.Office.Tools.Excel Namespace