PivotTable.CalculatedMembers (Excel)

Returns a CalculatedMembers collection representing all the calculated members and calculated measures for an OLAP PivotTable.

This property is used for Online Analytical Processing (OLAP) sources; a non-OLAP source will return a run-time error.

Dim cmsCalculatedMembers As CalculatedMembers
Set cmsCalculatedMembers = ActiveCell.PivotTable.CalculatedMembers