Ranges


ColumnRange

objPivotTable.ColumnRange 

Returns the range that represents the column area.



DataBodyRange

objPivotTable.DataBodyRange 

Returns the range that represents the data area.



RowRange

objPivotTable.RowRange 

Returns the range that represents the row area.



DataLabelRange

objPivotTable.DataLabelRange 

Returns the range that represents the labels for the data fields
This is read only



PageRange

objPivotTable.PageRange 

Returns the range that represents the page area (smallest rectangle area)



PageRangeCells

objPivotTable.PageRangeCells 

Returns the range that represents just the cells containing page related information (buttons, drop-downs)
This will probably be a discontinuous range.



TableRange1

objPivotTable.TableRange1 

Returns the range that represents the entire pivot table (excluding the page fields)



TableRange2

objPivotTable.TableRange2 

Returns the range that represents the entire pivot table (including the page fields)




© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext