Share via


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

See Also

Concepts

PivotField Object

PivotField Object Members