PivotField.Value (Excel)

Returns or sets a String value that represents the name of the specified field in the PivotTable report.

ActiveCell.PivotField.Value =