Skip to main content

PivotField object

Table of contents
  1. Remarks
  2. Example

Represents a field in a PivotTable report.


The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.

In some cases, it may be easier to use one of the properties that returns a subset of the PivotTable fields. The following properties are available:


Use PivotFields (index), where index is the field name or index number, to return a single PivotField object.

The following example makes the Year field a row field in the first PivotTable report on Sheet3.

Worksheets("sheet3").PivotTables(1).PivotFields("year").Orientation = xlRowField

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>