ListRow Object

Microsoft Excel Visual Basic

ListRow Object

ListObject ListRows
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