SolveOrder Property [Excel 2003 VBA Language Reference]

Returns a Long specifying the value of the calculated member's solve order MDX (Mulitdimensional Expression) argument. The default value is zero. Read-only.


expression Required. An expression that returns a CalculatedMember object.


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."
        MsgBox "The solve order is not set to the default value."
    End If

End Sub

Applies to | CalculatedMember Object