SolveOrder Property

Microsoft Excel Visual Basic

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