SelectionMode Property

See Also         Example         Applies To

Returns or sets the PivotTable report structured selection mode. Can be one of the following XlPTSelectionMode constants: xlLabelOnly, xlDataAndLabel, xlDataOnly or, if the specified PivotTable field is in outline form, the sum of any of these constants and xlFirstRow. Read/write Long.

Remarks

If the PivotTable field isn’t in outline form, specifying the sum of any of the constants and xlFirstRow is equivalent to specifying the constant alone.