Skip to content

Latest commit

 

History

History
40 lines (25 loc) · 886 Bytes

Excel.PivotTable.PageFieldWrapCount.md

File metadata and controls

40 lines (25 loc) · 886 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotTable.PageFieldWrapCount property (Excel)
vbaxl10.chm235121
vbaxl10.chm235121
Excel.PivotTable.PageFieldWrapCount
930bfe25-362e-f907-d593-6898db07f55b
05/09/2019
medium

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

expression.PageFieldWrapCount

expression 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

[!includeSupport and feedback]