Share via

InsertRowRange Property

  • Article

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.

There is no InsertRowRange property if the entry is read only as in the case of view-only mode. When there is no insert row, ListObject.InsertRowRange returns nothing.

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)

Applies to | ListObject Object