PivotCell.RowItems property (Excel)

Returns a PivotItemList collection that corresponds to the items on the category axis that represent the selected cell.



expression A variable that represents a PivotCell object.


This example determines if the data item in cell B5 is under the Inventory item in the first row field and notifies the user. The example assumes that a PivotTable exists on the active worksheet, and that column B of the worksheet contains a row item of the PivotTable.

Sub CheckRowItems() 
 ' Determine if there is a match between the item and row field. 
 If Application.Range("B5").PivotCell.RowItems.Item(1) = "Inventory" Then 
 MsgBox "Cell B5 is a member of the 'Inventory' row field. 
 MsgBox "Cell B5 is not a member of the 'Inventory' row field. 
 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.