PivotSelection Property Example

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

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