Microsoft Office Tutorials and References
In Depth Information
Figure 20-13. The DataLabelRange range
This read-only property returns a Range object that represents the labels for the PivotTable data
fields. Figure 20-13 illustrates DataLabelRange.
Figure 20-13. The DataLabelRange range
20.5.3.4 PageRange and PageRangeCells properties
The PageRange property returns a Range object that represents the PivotTable's page area. This is
the smallest rectangular region containing all page field-related cells.
The PageRangeCells property returns a Range object that represents just the cells in the
PivotTable containing the page-field buttons and item drop-down lists. Figure 20-14 and Figure
20-15 illustrate the difference.
Figure 20-14. The PageRange range
Figure 20-15. The PageRangeCells range
20.5.3.5 RowRange property
 
 
 
Search JabSto ::




Custom Search