Edit

Share via

CalculatedMember.SolveOrder property (Excel)

  • Article

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 that 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.