PivotTable.PivotValueCell(Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

PivotValueCell

Applies to