共用方式為


PivotTable.PageRange Property (Excel)

Returns a Range object that represents the range that contains the page area in the PivotTable report. Read-only.

Syntax

expression .PageRange

expression A variable that represents a PivotTable object.

Example

This example selects the page headers in the PivotTable report.

Worksheets("Sheet1").Activate 
Range("A3").Select 
ActiveCell.PivotTable.PageRange.Select

請參閱

概念

PivotTable Object

PivotTable Object Members