ListRows.Add Method (Excel)

Adds a new row to the table represented by the specified ListObject.

expression .Add(Position, AlwaysInsert)

expression A variable that represents a ListRows object.

Parameters

Name

Required/Optional

Data Type

Description

Position

Optional

Variant

Integer. Specifies the relative position of the new row.

AlwaysInsert

Optional

Variant

Boolean. Specifies whether to always shift data in cells below the last row of the table when the new row is inserted, regardless if the row below the table is empty. If True, the cells below the table will be shifted down one row. If False, if the row below the table is empty, the table will expand to occupy that row without shifting cells below it; but if the row below the table contains data, those cells will be shifted down when the new row is inserted.

Return Value

A ListRow object that represents the new row.

If Position is not specified, a new bottom row is added. If AlwaysInsert is not specified, the cells below the table will be shifted down one row (same as specifying True).

The following example adds a new row to the default ListObject object in the first worksheet of the workbook. Because no position is specified, the new row is added to the bottom of the list.

Set myNewColumn = ActiveWorkbook.Worksheets(1).ListObject(1).ListRows.Add

Community Additions

ADD
Show:
© 2014 Microsoft