Edit

Share via

Top10.CalcFor property (Excel)

  • Article

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

Syntax

expression.CalcFor

expression A variable that represents a Top10 object.

Remarks

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.