Top10.CalcFor Property
| Excel Developer Reference |
Returns or sets one of the constants of the XlCalcFor enumeration, which specifies how the conditional format in a PivotTable report should be evaluated.
Version Information
Version Added: Excel 2007
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 Top10.ScopeType property is set to xlFieldsScope.
See Also