This documentation is archived and is not being maintained.

ListRow Object [Excel 2003 VBA Language Reference]

Office 2003
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


Show: