ListRow Object
ListRow
Range
Represents a row in a List object. The ListRow object is a member of the ListRows collection. The ListRows collection contains all the rows in a list object.
Using the ListRow Object
Use the ListRows property of the ListObject object to return a ListRows Object collection. 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 list.
Dim wrksht As Worksheet
Dim oListRow As ListRow
Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
Set oListRow = wrksht.ListObjects(1).ListRows.Add