PivotTable.ShowPages Method (Excel)
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.”
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.ShowPages "Country"