Share via

PivotCell.CustomSubtotalFunction Property

  • Article
Excel Developer Reference

Returns the custom subtotal function field setting of a PivotCell object. Read-only XlConsolidationFunction.

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.<strong>CustomSubtotalFunction</strong> = 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

See Also