PivotTable.GetPivotData (Excel)

Returns a Range object with information about a data item in a PivotTable report.

GetPivotData (DataField, Field1, Item1, Field2, Item2, Field3, Item3, Field4, Item4, Field5, Item5, Field6, Item6, Field7, Item7, Field8, Item8, Field9, Item9, Field10, Item10, Field11, Item11, Field12, Item12, Field13, Item13, Field14, Item14)

Dim rngGetPivotData As Range
Set rngGetPivotData = ActiveCell.PivotTable.GetPivotData()

Arguments

Optional arguments

The following arguments are optional

DataField (String) - The name of the field containing the data for the PivotTable.

Field1 (String) - The name of a column or row field in the PivotTable report.

Item1 (String) - The name of an item in Field1.

Field2 (String) - The name of a column or row field in the PivotTable report.

Item2 (String) - The name of an item in Field2.

Field3 (String) - The name of a column or row field in the PivotTable report.

Item3 (String) - The name of an item in Field3.

Field4 (String) - The name of a column or row field in the PivotTable report.

Item4 (String) - The name of an item in Field4.

Field5 (String) - The name of a column or row field in the PivotTable report.

Item5 (String) - The name of an item in Field5.

Field6 (String) - The name of a column or row field in the PivotTable report.

Item6 (String) - The name of an item in Field6.

Field7 (String) - The name of a column or row field in the PivotTable report.

Item7 (String) - The name of an item in Field7.

Field8 (String) - The name of a column or row field in the PivotTable report.

Item8 (String) - The name of an item in Field8.

Field9 (String) - The name of a column or row field in the PivotTable report.

Item9 (String) - The name of an item in Field9.

Field10 (String) - The name of a column or row field in the PivotTable report.

Item10 (String) - The name of an item in Field10.

Field11 (String) - The name of a column or row field in the PivotTable report.

Item11 (String) - The name of an item in Field11.

Field12 (String) - The name of a column or row field in the PivotTable report.

Item12 (String) - The name of an item in Field12.

Field13 (String) - The name of a column or row field in the PivotTable report.

Item13 (String) - The name of an item in Field13.

Field14 (String) - The name of a column or row field in the PivotTable report.

Item14 (String) - The name of an item in Field14.