DataBodyRange Property

Microsoft Excel Visual Basic

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.

Example

This example selects the active data range in the list.

Worksheets("Sheet1").Activate
ActiveWorksheet.ListObjects.Item(1).DataBodyRange.Select