ListObject.ListRows Property

Syntax

expression.ListRows

expression A variable that represents a ListObject object.

Remarks

The ListRows object returned does not include the header, total, or Insert rows.

Example

The following example deletes a row specified by number in the ListRows collection that is created by a call to the ListRows property.

Visual Basic for Applications

Visual Basic for Applications
`Sub DeleteListRow(iRowNumber As Integer) Dim wrksht As Worksheet Dim objListObj As ListObject Dim objListRows As ListRows Set wrksht = ActiveWorkbook.Worksheets("Sheet1") Set objListObj = wrksht.ListObjects(1) Set objListRows = objListObj.ListRows If (iRowNumber <> 0) And (iRowNumber < objListRows.Count - 1) Then objListRows(iRowNumber).Delete End If End Sub`

Sub DeleteListRow(iRowNumber As Integer) Dim wrksht As Worksheet Dim objListObj As ListObject Dim objListRows As ListRows Set wrksht = ActiveWorkbook.Worksheets("Sheet1") Set objListObj = wrksht.ListObjects(1) Set objListRows = objListObj.ListRows If (iRowNumber <> 0) And (iRowNumber < objListRows.Count - 1) Then objListRows(iRowNumber).Delete End If End Sub

list rows ListRows ListRows property

Returns a ListRows object that represents all the rows of data in the ListObject object. Read-only.

See also: