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.