Home Library Learn Samples Downloads Support Community Forums
This topic has not yet been rated - Rate this topic

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

See Also


Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.