Microsoft Office Tutorials and References
In Depth Information
20.6 Children of the PivotTable Object
debug.print ActiveSheet.PivotTables("Sales&Trans").SourceData
returns the string:
'Company Both'!R1C1:R145C7
20.6 Children of the PivotTable Object
The children of the PivotTable object are shown in Figure 20-23 .
Figure 20-23. Children of the PivotTable object
20.7 The PivotField Object
The properties and methods of the PivotField object are shown in Table 20-3 .
Tabl e 20-3. Members of the Pivot Field Object
_Default
CurrentPageName<v9>
LayoutPageBreak<v9>
 
 
 
 
Search JabSto ::




Custom Search