Creates a new PivotTable report for each item in the page field. Each new report is created on a new worksheet.
Syntax
expression.ShowPages(PageField)
expression A variable that represents a PivotTable object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|
| PageField | Optional | Variant | A string that names a single page field in the report. |
Return Value
Variant
Remarks
This method isn’t available for OLAP data sources.
Example
This example creates a new PivotTable report for each item in the page field, which is the field named “Country.”
| Visual Basic for Applications |
|---|
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.ShowPages "Country"
|