PivotField.IsMemberProperty Property

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

See also:

• PivotField Object
• PivotField Object Members