Share via

CalculatedMember.SolveOrder Property

  • Article
Excel Developer 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.

Syntax

expression.SolveOrder

expression   A variable that represents 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.

Visual Basic for Applications 
  Sub CheckSolveOrder()

Dim pvtTable As PivotTable

Set pvtTable = ActiveSheet.PivotTables(1)

' Determine solve order and notify user.
If pvtTable.CalculatedMembers.Item(1).<strong class="bterm">SolveOrder</strong> = 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

See Also