Syntax

expression.PivotSelection

expression A variable that represents a PivotTable object.

Remarks

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

Example

This example selects the data and label for the salesperson named Bob in the first PivotTable report on worksheet one.

Visual Basic for Applications 
Worksheets(1).PivotTables(1).PivotSelection = "Salesman[Bob]"
Get hold of a specific pivottable selection? pivot pivot selection Pivot Selection Property PivotSelection PivotSelection Property Return or set all data and labels in pivottable?

See also:

Mode