ListRow Object

  • Article
Excel Developer Reference

Represents a row in a table. The ListRow object is a member of the ListRows collection.

Remarks

The ListRows collection contains all the rows in a list object.

Use the ListRows property of the ListObject object to return a ListRows collection.

Example

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

Visual Basic for Applications 
  Dim wrksht As Worksheet
Dim oListRow As ListRow
   
Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
Set oListRow = wrksht.ListObjects(1).ListRows.Add

See Also