ListRow Object

ListObject ListRows
ListRow
Multiple objects

Using the ListRow Object

A ListRow object represents a row in a ListObject object in a Spreadsheet component. The ListRow object is a member of the ListRows collection. The ListRows collection contains all the rows in a ListObject object. The ListRow object has no default property.

Individual ListRow objects in the ListRows collection are indexed beginning with 1 for the first object, 2 for the second object, and so forth. You use the Item property to return a single ListRow object from the ListRows collection. The argument for the Item property is the index number in the ListRows collection of the ListRow object.

You use the Delete method to delete the cells of a row in a list. Deleting the row will cause a shift up for the remaining cells below the deleted row. The read/write Active property of the ListRow object allows you to find out if a row is selected or to select it. You use the Range property to return a Range object that represents the range to which the specified list row applies.

You find out the current ordinal position of the ListRow object in the ListRows collection using the Index property. The Application and Parentproperties return the Spreadsheet component and the parent object (which is the ListObject object) for the specified ListRows object.