| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotField.CurrentPage property (Excel) |
vbaxl10.chm240077 |
|
|
4a59fe58-8f95-4cf3-d4a3-ab6ea6b24b8a |
05/04/2019 |
medium |
Returns or sets the current page showing for the page field (valid only for page fields). Read/write PivotItem.
expression.CurrentPage
expression A variable that represents a PivotField object.
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[!includeSupport and feedback]