InsertRowRange Property

Returns the Range object of the insert row, if any, from a specified ListObject object. Read-only.

expression .InsertRowRange

expression    Required. An expression that returns a ListObject object.

Remarks

Some Range properties and methods are not supported. The properties not supported are Locked, MergeArea and MergeCells. The methods not supported are Delete, Insert, Merge, and UnMerge. If the insert row is not currently visible, the Nothing object will be returned.

You can reference any cell in the insert row using the InsertRowRange property. Properties of the border of the Range returned by the InsertRowRange property are not saved after a new row is added to an XML list.

Example

The example below gets the insert row range information and displays it.

    
    Dim rngInsertRow
Dim objList
        
Set objList = Spreadsheet1.Worksheets(1).ListObjects(1)

' Save the insert range information to a variable.
Set rngInsertRow = objList.InsertRowRange

MsgBox ("The insert row range is: " & Chr(10) & rngInsertRow.Address)