ListObject.DataBodyRange Property (Excel)
Returns a Range object that represents the range of values, excluding the header row, in a table. Read-only.
Syntax
expression .DataBodyRange
expression A variable that represents a ListObject object.
Example
This example selects the active data range in the list.
Worksheets("Sheet1").Activate
ActiveWorksheet.ListObjects.Item(1).DataBodyRange.Select