Applies To
PivotTable Object.
Description
Creates a new PivotTable for each item in the page field. Each new PivotTable is created on a new worksheet.
Syntax
object.ShowPages(pageField)
object
Required. The PivotTable object.
pageField
Required. A string that names a single page field in the PivotTable.
Example
This example creates a new PivotTable for each item in the page field, which is the field named "Country."
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.ShowPages "Country"