PivotTable.PageFieldWrapCount Property (Excel)

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

Syntax

.PageFieldWrapCount

A variable that represents a PivotTable object.

Example

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

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

참고 항목

개념

PivotTable Object

PivotTable Object Members