Applies To
Range Object.
Description
Accessor. Returns a PivotTable object that represents the PivotTable containing the top 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"