Share via


WorksheetBase.HPageBreaks Property

Gets an Microsoft.Office.Interop.Excel.HPageBreaks collection that represents the horizontal 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 HPageBreaks As HPageBreaks
public HPageBreaks HPageBreaks { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.HPageBreaks
An Microsoft.Office.Interop.Excel.HPageBreaks collection that represents the horizontal page breaks on the sheet.

Remarks

There is a limit of 1026 horizontal page breaks per sheet.

Examples

The following code example uses the HPageBreaks property to add a horizontal 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"]);
    Excel.VPageBreak vbreak =
        this.VPageBreaks.Add(this.Range["C5"]);
}

.NET Framework Security

See Also

Reference

WorksheetBase Class

Microsoft.Office.Tools.Excel Namespace