LayoutPageBreak Property Example

This example adds a page break after the state field in the first PivotTable report on the active worksheet.

With ActiveSheet.PivotTables("PivotTable1") _
        .PivotFields("state")
    .LayoutPageBreak = True
End With