PivotSelect Method

Applies To

PivotTable object.

Description

Selects part of a PivotTable.

Syntax

expression.PivotSelect(Name, Mode)

expression An expression that returns a PivotTable object.

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

Mode Required Long. Specifies the structured selection mode. Can be one of the following XlPTSelectionMode constants: xlBlanks, xlButton, xlDataAndLabel, xlDataOnly, xlLabelOnly, or xlOrigin.

Example

This example selects all date labels in PivotTable one.

Worksheets(1).PivotTables(1).PivotSelect "date[All]", xlLabelOnly