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"
Create a different table for every item in a page field? Produce a new pivottable for each page item? show pages Show Pages Method ShowPages ShowPages Method

See also: