This documentation is archived and is not being maintained.

ListRows Collection [Excel 2003 VBA Language Reference]

Office 2003
ListObject
ListRows
ListRow
Range

A collection of all the ListRow objects in the specified

Visit

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


Methods | Add Method

Parent Objects | ListObject

Child Objects | Range



Show: