Share via

PivotCell.PivotTable Property (Excel)

  • 아티클

Returns a PivotTable object that represents the PivotTable report associated with the PivotCell.

Syntax

식 .PivotTable

식 A variable that represents a PivotCell object.

Example

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

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

This example determines the PivotTable report associated with the Sales chart on the active worksheet, and then it sets the page named "Oregon" as the current page for the PivotTable report.

Set objPT = _ 
 ActiveSheet.Charts("Sales").PivotLayout.PivotTable 
objPT.PivotFields("State").CurrentPageName = "Oregon"

참고 항목

개념

PivotCell Object Members

PivotCell Object