PageFieldWrapCount Property

Applies To

PivotTable object.

Description

Returns or sets the number of PivotTable page fields in each column or row. Read/write Long.

See Also

PageFieldOrder property.

Example

This example causes the PivotTable to draw three page fields in a row before starting a new row.

With Worksheets(1).PivotTables("Pivot1")
    .PageFieldOrder = xlOverThenDown
    .PageFieldWrapCount = 3
End With