Programming Excel with VBA and .NET

Name

pivottable.AddFields([RowFields], [ColumnFields], [PageFields], [AddToTable])

Synopsis

Adds fields to the row, column, or page areas of a pivot table.

Argument	Settings
RowFields	The PivotField objects to add to the row area.
ColumnFields	The PivotField objects to add to the column area.
PageFields	The PivotField objects to add to the page area.
AddToTable	True appends the fields to any existing fields in the table; False replaces any existing fields in the table with the new ones.

To add multiple fields to an area, use an array of PivotField objects for the RowFields, ColumnFields, or PageFields arguments.