Share via


ListObject.DataBodyRange Property

Excel Developer Reference

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.

Visual Basic for Applications
  Worksheets("Sheet1").Activate
ActiveWorksheet.ListObjects.Item(1).DataBodyRange.Select

See Also