Skip to main content

PivotItem object

Table of contents
  1. Remarks
  2. Example

Represents an item in a PivotTable field.

Remarks

The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object.

Example

Use PivotItems (index), where index is the item index number or name, to return a single PivotItem object.

The following example hides all entries in the first PivotTable report on Sheet3 that contain "1998" in the Year field.

Worksheets("sheet3").PivotTables(1).PivotFields("year").PivotItems("1998").Visible = False

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>