ListRow Object [Excel 2003 VBA Language Reference]
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
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