ListObject.DataBodyRange Property

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

See Also

• ListObject Object
• ListObject Object Members