ListObject.InsertRowRange Property

Gets a Range that represents the Insert row, if any, of the ListObject control.

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

Syntax

'Declaration
ReadOnly Property InsertRowRange As Range
    Get

Range InsertRowRange { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Range
A Range that represents the Insert row, if any, of the ListObject control.

Remarks

If there is no Insert row, InsertRowRange returns nulla null reference (Nothing in Visual Basic).

Examples

The following code example creates a ListObject, gets the range that contains the Insert row, and then displays a message showing how many cells the Insert row contains.

This example is for a document-level customization.

    Private Sub ListObject_InsertRowRange()
        Dim List1 As Microsoft.Office.Tools.Excel.ListObject = _
            Me.Controls.AddListObject(Me.Range("A1", "C4"), "List1")

        Dim insertRow As Excel.Range = List1.InsertRowRange
        MessageBox.Show("The insert row contains " & _
            insertRow.Cells.Count.ToString() & " cells.")
    End Sub

private void ListObject_InsertRowRange()
{
    Microsoft.Office.Tools.Excel.ListObject list1 =
        this.Controls.AddListObject(
        this.Range["A1", "C4"], "list1");

    Excel.Range insertRow = list1.InsertRowRange;
    MessageBox.Show("The insert row contains " + 
        insertRow.Cells.Count.ToString() +
        " cells.");
}

.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

ListObject Interface

Microsoft.Office.Tools.Excel Namespace