Syntax

expression.CustomSubtotalFunction

expression A variable that represents a PivotCell object.

Remarks

XlConsolidationFunction can be one of these XlConsolidationFunction constants.
xlAverage
xlCount
xlCountNums
xlMax
xlMin
xlProduct
xlStDev
xlStDevP
xlSum
xlUnknown
xlVar
xlVarP

The CustomSubtotalFunction property will return an error if the PivotCell object type is not a custom subtotal. This property applies only to non-OLAP source data .

Example

This example determines if cell C20 contains a custom subtotal function that uses a consolidation function of count and then it notifies the user. The example assumes a PivotTable exists on the active worksheet.

Visual Basic for Applications 
Sub UseCustomSubtotalFunction() On Error GoTo Not_A_Function ' Determine if custom subtotal function is a count function. If Application.Range("C20").PivotCell.CustomSubtotalFunction = xlCount Then MsgBox "The custom subtotal function is a Count." Else MsgBox "The custom subtotal function is not a Count." End If Exit Sub Not_A_Function: MsgBox "The selected cell is not a custom subtotal function." End Sub
custom subtotal function customsubtotal customsubtotalfunction customsubtotalfunction property

See also: