PivotField.CurrentPage Property (Excel)
Returns or sets the current page showing for the page field (valid only for page fields). Read/write PivotItem.
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.
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
strPgName = pvtTable.PivotFields("Country").CurrentPage.Name