Top10.CalcFor property (Excel)

Returns or sets one of the constants of the XlCalcFor enumeration, which specifies how the conditional format in a PivotTable report should be evaluated.



expression A variable that represents a Top10 object.


This property is applicable only when the conditional format is being applied to data in a PivotTable report.

This property can be set to xlAllValues, xlColGroups, or xlRowGroups only if the ScopeType property is set to xlFieldsScope.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.