expression.SolveOrder
expression Required. An expression that returns a CalculatedMember object.
Example
This example determines the solve order for a calculated member and notifies the user. The example assumes a PivotTable exists on the active worksheet.
Sub CheckSolveOrder()
Dim pvtTable As PivotTable
Set pvtTable = ActiveSheet.PivotTables(1)
' Determine solve order and notify user.
If pvtTable.CalculatedMembers.Item(1).SolveOrder = 0 Then
MsgBox "The solve order is set to the default value."
Else
MsgBox "The solve order is not set to the default value."
End If
End Sub