Pivot Cell Properties

Name

Returns

Description

ColumnItems

PivotItemList

Read-only. Returns the items that represent the selected range on the column axis

Custom Subtotal Function

Xl Consolidation Function

Read-only. Returns the custom subtotal function field setting of the PivotCell

DataField

PivotField

Read-only. Returns the selected data field

PivotCellType

XlPivotCellType

Read-only. Returns the PivotTable entity that the selected cell corresponds to

PivotColumnLine

PivotLine

Returns the PivotLine on a column if the specified PivotCell is in the Column Area. This property will return an error for PivotCells in the Row area

PivotField

PivotField

Read-only. Returns the PivotTable field containing the upper-left corner of the specified range

PivotItem

PivotItem

Read-only. Returns the PivotTable item containing the upper-left corner of the specified range

PivotRowLine

PivotLine

Returns the PivotLine on a row if the specified PivotCell is in the Row Area. This property will return an error for PivotCells in the Column area

PivotField Object, PivotFields Collection, and the CalculatedFields Collection

Name

Returns

Description

PivotTable

PivotTable

Read-only. Returns the PivotTable report containing the upper-left corner of the specified range, or the PivotTable report associated with the PivotChart report

Range

Range

Read-only. Returns the range to which the specified PivotCell applies

RowItems

PivotItemList

Read-only. Returns the items that represent the selected range on the row axis

0 0

Post a comment