Worksheet.ConsolidationFunction Property

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`

consolidation consolidation function Consolidation Function Property Consolidation function? ConsolidationFunction ConsolidationFunction Property Return consolidation mode? Tell how consolidations are currently being done? What method is the current consolidation using for calculation?

Worksheet.ConsolidationFunction Property

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

See also: