PivotTable.GetData (Excel)

Returns the value for the data filed in a PivotTable.

GetData (Name)

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

Dim strName As String: strName = 
Dim dblGetData As Double
dblGetData = ActiveCell.PivotTable.GetData(Name:=strName)