PivotSelect Method

PivotSelect Method

         Example         Applies To

Selects part of a PivotTable report.

Syntax

expression.PivotSelect(Name, Mode)

expression   An expression that returns a PivotTable object.

Name   Required String. The selection, in standard PivotTable report selection format.

Mode   Optional Long. Specifies the structured selection mode. Can be one of the following XlPTSelectionMode constants: xlBlanks, xlButton, xlDataAndLabel, xlDataOnly, xlFirstRow, xlLabelOnly, or xlOrigin. The default constant is xlDataAndLabel.

Remarks

You can use the specified mode only to select the corresponding item in the PivotTable report. For example, you cannot select data and labels by using xlButton mode; likewise, you cannot select buttons by using xlDataOnly mode.