RepeatItemsOnEachPrintedPage Property Example

This example sets Microsoft Excel to repeat the labels on each page when the fourth PivotTable report on the active worksheet is printed.

ActiveSheet.PivotTables("PivotTable4") _
    .RepeatItemsOnEachPrintedPage = True