Microsoft Office Tutorials and References
In Depth Information
20.5.3 Returning a Portion of a PivotTable
20.5.3 Returning a Portion of a PivotTable
Several of the members of the PivotTable object are designed to return a portion of the pivot table
as a Range object. They are as follows.
20.5.3.1 ColumnRange property
This property returns a Range object that represents the column area in the pivot table. Figure 20-
illustrates the column range. 11
Figure 20-11. The ColumnRange range
20.5.3.2 DataBodyRange property
This property returns a Range object that represents the PivotTable's data area. Figure 20-12
shows the results of selecting the DataBodyRange.
Figure 20-12. The DataBodyRange range
20.5.3.3 DataLabelRange property
 
 
 
Search JabSto ::




Custom Search