ConsolidationFunction Property [Excel 2003 VBA Language Reference]

  • Article

XlConsolidationFunction

XlConsolidationFunction can be one of these XlConsolidationFunction constants.
xlAverage
xlCount
xlCountNums

xlMax

xlMin

xlProduct

xlStDev

xlStDevP

xlSum

xlUnknown

xlVar

xlVarP

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

Applies to | Worksheet Object

See Also | Consolidate Method | ConsolidationOptions Property | ConsolidationSources Property