PivotField.CurrentPage Property

  • Article
Excel Developer Reference

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.

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

See Also