ListObject.ListRows (Excel)

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

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

Dim lrsListRows As ListRows
Set lrsListRows = ActiveCell.ListObject.ListRows