PivotTable.RowFields Property

Syntax

expression.RowFields(Index)

expression A variable that represents a PivotTable object.

Parameters

Name	Required/Optional	Data Type	Description
Index	Optional	Variant	The name or number of the field to be returned (can be an array to specify more than one field).

Example

This example adds the PivotTable report's row field names to a list on a new worksheet.

Visual Basic for Applications

Visual Basic for Applications
`Set nwSheet = Worksheets.Add nwSheet.Activate Set pvtTable = Worksheets("Sheet2").Range("A1").PivotTable rw = 0 For Each pvtField In pvtTable.RowFields rw = rw + 1 nwSheet.Cells(rw, 1).Value = pvtField.Name Next pvtField`

Set nwSheet = Worksheets.Add nwSheet.Activate Set pvtTable = Worksheets("Sheet2").Range("A1").PivotTable rw = 0 For Each pvtField In pvtTable.RowFields rw = rw + 1 nwSheet.Cells(rw, 1).Value = pvtField.Name Next pvtField

Return one or all of the pivotfields showing as row fields? row fields Row Fields Property RowFields RowFields Property

Returns an object that represents either a single field in a PivotTable report (a PivotField object) or a collection of all the fields (a PivotFields object) that are currently showing as row fields. Read-only.

See also: