Returns True when the PivotField contains member properties. Read-only Boolean.
expression.IsMemberProperty
expression Required. An expression that returns a PivotField object.
This property will return a run-time error if an Online Analytical Processing (OLAP) data source is not used.
This example determines if the PivotTable field contains member properties and notifies the user. It assumes that a PivotTable exists on the active worksheet and that it is connected to an OLAP data source.
Sub CheckForMembers()
Dim pvtTable As PivotTable
Dim pvtField As PivotField
Set pvtTable = ActiveSheet.PivotTables(1)
Set pvtField = pvtTable.PivotFields(1)
' Determine if member properties exist and notify user.
If pvtField.IsMemberProperty = True Then
MsgBox "The PivotField contains member properties."
Else
MsgBox "The PivotField does not contain member properties."
End If
End Sub