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