PivotItem Object [Excel 2003 VBA Language Reference]
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
Properties | Application Property | Caption Property | ChildItems Property | Creator Property | DataRange Property | DrilledDown Property | Formula Property | IsCalculated Property | LabelRange Property | Name Property | Parent Property | ParentItem Property | ParentShowDetail Property | Position Property | RecordCount Property | ShowDetail Property | SourceName Property | SourceNameStandard Property | StandardFormula Property | Value Property | Visible Property
Methods | Delete Method
Parent Objects | PivotCell Object | PivotItem Object | Range Collection
Child Objects | PivotField Object | PivotItem Object | Range Object
See Also | PivotCache Object | PivotCell Object | PivotField Object | PivotFormula Object | PivotItemList Collection | PivotLayout Object | PivotTable Object