PivotTable.PivotValueCell method (Excel)

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

Syntax

expression.PivotValueCell (RowLine, ColumnLine)

expression A variable that represents a PivotTable object.

Parameters

Name	Required/Optional	Data type	Description
RowLine	Optional	Variant	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	Optional	Variant	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.

Return value

PIVOTVALUECELL

Example

This code sample uses the PivotValueCell property to test whether the value of one cell in a PivotTable is greater than the value of another cell.

Sub TestEquality()
Dim X As Double
Dim Y As Double

'This code assumes you have a Standalone PivotChart on one of the worksheets
X = ThisWorkbook.PivotTables(1).PivotValueCell(1, 1).Value
Y = ThisWorkbook.PivotTables(1).PivotValueCell(1, 2).Value

If X > Y Then
MsgBox "X is greater than Y"
Else
MsgBox "Y is greater than X"
End If
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.