Microsoft Office Tutorials and References
In Depth Information
Table 20-5. Members of the PivotItem Object
can return a single PivotItem object or an array of PivotItem objects (by setting Index to an array
of indexes).
Table 20-5 shows the properties and methods of the PivotItem object. Let us take a look at some
of these members. Note that several of the members of the PivotField object also apply to the
PivotItem object.
ble 20-5. Members of the PivotItem Object
Application
IsCalculated
Position
ChildItems
LabelRange
RecordCount
Creator
Name
ShowDetail
DataRange
Parent
SourceName
Delete
ParentItem
Value
Formula
ParentShowDetail
Visible
20.9.1 DataRange Property
This property returns a Range object representing the data area associated with the given
PivotItem. To illustrate, the code:
ActiveSheet.PivotTables("Sales&Trans"). _
PivotFields("Store Type"). _
PivotItems("Company").DataRange.Select
results in Figure 20-37 .
Figure 20-37. DataRange for Store Type = Company
20.9.2 LabelRange Property
The LabelRange property returns a Range object that represents the label cells for the PivotItem.
Figure 20-38 illustrates the results of the code:
ActiveSheet.PivotTables("Sales&Trans"). _
 
 
 
Search JabSto ::




Custom Search