PivotTable.PivotValueCell (Excel)

Retrieve the PivotValueCell object for a given PivotTable provided certain row and column indices.

PivotValueCell (rowline, columnline)


Dim pvc As PivotValueCell
Set pvc = ActiveCell.PivotTable.PivotValueCell()

Arguments

Optional arguments

The following arguments are optional

rowline (PivotValueCell) - If of type PivotLine, specifies the PivotLine in the row area that the PivotValueCell is aligned with. If of type Int, specifies the position of the PivotLine on the row area that the PivotValueCell is aligned with. If missing, Empty, Null, or 0 specifies the grand total row.

columnline (PivotValueCell) - If of type PivotLine, specifies the PivotLine in the column area that the PivotValueCell is aligned with. If of type Int, specifies the position of the PivotLine on the column area that the PivotValueCell is aligned with. If missing, Empty, Null or 0 specifies the grand total column.