ListRow Object [Excel 2003 VBA Language Reference]


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

Properties | Application Property | Creator Property | Index Property | InvalidData Property | Parent Property | Range Property

Methods | Delete Method

Parent Objects | ListObject

Child Objects | Range

See Also | ListColumn Object