GetData Method

Microsoft Excel Visual Basic

GetData Method

       

expression.GetData(Name)

expression   Required. An expression that returns a PivotTable object.

Name   Required String. Describes a single cell in the PivotTable report, using syntax similar to the PivotSelect method or the PivotTable report references in calculated item formulas.

Example

This example shows the sum of revenues for apples in January (Data field = Revenue, Product = Apples, Month = January).

Msgbox ActiveSheet.PivotTables(1) _
    .GetData("'Sum of Revenue' Apples January")