Export (0) Print
Expand All

PivotItem Object [Excel 2003 VBA Language Reference]

Office 2003
Multiple objects
PivotItem
Multiple objects

Represents an item in a PivotTable field. 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.

Using the PivotItem Object

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
		


Methods | Delete Method



Show:
© 2014 Microsoft