Edit

Share via


PivotTable.PivotValueCell(Object, Object) Method

Definition

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

public Microsoft.Office.Interop.Excel.PivotValueCell PivotValueCell (object rowline, object columnline);
Public Function PivotValueCell (Optional rowline As Object, Optional columnline As Object) As PivotValueCell

Parameters

rowline
Object

If of type PivotLine, specifies the PivotLine in the row area that the PivotValueCell is aligned with. If of type Int, then specifies 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
Object

If of type PivotLine, specifies the PivotLine in the column area that the PivotValueCell is aligned with. If of type Int, then specifies 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.

Returns

Applies to