PivotField.CurrentPage Property

Syntax

expression.CurrentPage

expression A variable that represents a PivotField object.

Example

This example returns the current page name for the PivotTable report on Sheet1 in the string variable strPgName.

Visual Basic for Applications
`Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable strPgName = pvtTable.PivotFields("Country").CurrentPage.Name`

Change the current page for pivot table? current page Current Page Property currentPage CurrentPage Property Set the value of the page field?

Returns or sets the current page showing for the page field (valid only for page fields). Read/write PivotItem.