Pivot Line Object the Pivot Lines Collection and the Pivot LinesCells Collection

The PivotLine object defines the profile of a particular row or column. Each row and column in a PivotTable is a Regular line, a Blank line, a SubTotal line, or a GrandTotal line. The PivotLines collection contains all of the PivotLine objects in a given PivotTable. The PivotCells collection represents the each PivotCell within a given PivotLine. The PivotLines and PivotLinesCells collections have no properties and methods outside the typical collection attributes listed at the beginning of this appendix.

0 0

Post a comment