PivotField.RepeatLabels (Excel)

Returns or sets whether item labels are repeated in the PivotTable for the specified PivotField.

True if item labels are repeated for the specified PivotField; otherwise, False. The setting of the RepeatLabels property corresponds to the Repeat item labels check box on the Layout & Print tab of the Field Settings dialog box for a field in a PivotTable. To specify whether to repeat item labels for all PivotFields in a PivotTable in a single operation, use the RepeatAllLabels method.

ActiveCell.PivotField.RepeatLabels = True