PivotTable.ShowPages Method
Excel Developer Reference |
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 |
---|
|
See Also