Returns a Range
object that represents the range that contains the data area in the list between the header row and the insert row. Read-only.
This example selects the active data range in the list.
Worksheets("Sheet1").Activate
ActiveWorksheet.ListObjects.Item(1).DataBodyRange.Select