Returns or sets the PivotTable selection in standard PivotTable report selection format. Read/write String. This example selects the data and label for the salesperson named Bob in the first ...

Returns a Range object with information about a data item in a PivotTable report. DataField Optional Variant The name of the field containing the data for the PivotTable. Field1 Optional Variant The ...