Skip to content

Latest commit

 

History

History
45 lines (29 loc) · 1.17 KB

Excel.Range.PivotTable.md

File metadata and controls

45 lines (29 loc) · 1.17 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Range.PivotTable property (Excel)
vbaxl10.chm144177
vbaxl10.chm144177
Excel.Range.PivotTable
ae3f77dc-5098-d60f-0afc-f4f01dbc33f0
05/11/2019
medium

Range.PivotTable property (Excel)

Returns a PivotTable object that represents the PivotTable report containing the upper-left corner of the specified range.

Syntax

expression.PivotTable

expression A variable that represents a Range object.

Example

This example sets the current page for the PivotTable report on Sheet1 to the page named Canada.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable 
pvtTable.PivotFields("Country").CurrentPage = "Canada"

This example determines the PivotTable report associated with the Sales chart on the active worksheet, and then it sets the page named Oregon as the current page for the PivotTable report.

Set objPT = _ 
 ActiveSheet.Charts("Sales").PivotLayout.PivotTable 
objPT.PivotFields("State").CurrentPageName = "Oregon"

[!includeSupport and feedback]