Worksheet.ConsolidationFunction Property (Excel)
Returns the function code used for the current consolidation. Can be one of the constants of XlConsolidationFunction. Read-only Long.
Syntax
식 .ConsolidationFunction
식 A variable that represents a Worksheet object.
Example
This example displays a message box if the current consolidation is using the SUM function.
If Worksheets("Sheet1").ConsolidationFunction = xlSum Then
MsgBox "Sheet1 uses the SUM function for consolidation."
End If