PivotSelection Property

Applies To

PivotTable object.

Description

Returns or sets the PivotTable selection, in standard PivotTable selection format. Read/write String.

Remarks

Setting this property is equivalent to calling the PivotSelect method with the Mode argument set to xlDataAndLabel.

Example

This example selects the data and label for the salesperson named "Bob" in PivotTable one.

Worksheets(1).PivotTables(1).PivotSelection = "Salesman[Bob]"