ListRows.Add method (Excel)

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

Syntax

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.

Remarks

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).

Example

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 myNewRow = ActiveWorkbook.Worksheets(1).ListObject(1).ListRows.Add

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.