ListRows Collection [Excel 2003 VBA Language Reference]
ListObject ListRows ListRow Range |
A collection of all the ListRow objects in the specified
Visit ListObject
object. Each ListRow object represents a row in the list.
Using the ListRows Collection
Use the ListRows property of the ListObject object to return the ListRows Object collection. The following example adds a new row to the default ListObject object in the first worksheet of the workbook. Because no position is specified, a new row is added to the end of the list.
Set myNewRow = Worksheets(1).ListObject(0).ListRows.Add
Properties | Application Property | Count Property | Creator Property | Item Property | Parent Property
Methods | Add Method
Parent Objects | ListObject
Child Objects | Range
See Also | ListColumns Collection