This documentation is archived and is not being maintained.

Worksheet.ConsolidationFunction Property

Office 2007
Returns the function code used for the current consolidation. Can be one of the constants of XlConsolidationFunction. Read-only Long.

Syntax

expression.ConsolidationFunction

expression   A variable that represents a Worksheet object.

Example

This example displays a message box if the current consolidation is using the SUM function.

Visual Basic for Applications
If Worksheets("Sheet1").ConsolidationFunction = xlSum Then
    MsgBox "Sheet1 uses the SUM function for consolidation."
End If



Show: