Not
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Returns a Range object as shown in the following table. Read-only.
Syntax
expression.DataRange
expression A variable that represents a PivotItem object.
Remarks
| Object | Data range |
|---|---|
| Data field | Data contained in the field |
| Row, column, or page field | Items in the field |
| Item | Data qualified by the item |
Example
This example selects the PivotTable items in the field named REGION.
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
Worksheets("Sheet1").Activate
pvtTable.PivotFields("REGION").DataRange.Select
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.