PivotTable Property

Applies To

Range object.

Description

Returns a PivotTable object that represents the PivotTable containing the upper-left corner of the specified range. Read-only.

Example

This example sets the current page for the PivotTable on Sheet1 to the page named "Canada."

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.PivotFields("Country").CurrentPage = "Canada"