| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
ListObject.DataBodyRange property (Excel) |
vbaxl10.chm734082 |
|
|
fe906555-d006-8220-d9f8-59636cca68d5 |
04/30/2019 |
medium |
Returns a Range object that represents the range of values, excluding the header row, in a table. Read-only.
expression.DataBodyRange
expression A variable that represents a ListObject object.
This example selects the active data range in the list.
Worksheets("Sheet1").Activate
ActiveSheet.ListObjects.Item(1).DataBodyRange.Select[!includeSupport and feedback]