PageRange Property [Excel 2003 VBA Language Reference]

  • Article

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

Example

This example selects the page headers in the PivotTable report.

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

Applies to | PivotTable Object

See Also | ColumnRange Property | DataBodyRange Property | DataLabelRange Property | RowRange Property