PivotField.IsMemberProperty Property (Excel)
Returns True when the PivotField contains member properties. Read-only Boolean.
Syntax
expression .IsMemberProperty
expression A variable that represents a PivotField object.
Remarks
This property will return a run-time error if an Online Analytical Processing (OLAP) data source is not used.
Example
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