ConsolidationFunction Property

Applies To

Worksheet object.

Description

Returns the function code used for the current consolidation. Can be one of the following XlConsolidationFunction constants: xlAverage, xlCount, xlCountNums, xlMax, xlMin, xlProduct, xlStDev, xlStDevP, xlSum, xlVar, or xlVarP. Read-only Long.

See Also

Consolidate method, ConsolidationOptions property, ConsolidationSources property.

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