PivotItem.RecordCount property (Excel)
Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item. Read-only Long.
expression A variable that represents a PivotItem object.
This property reflects the transient state of the cache at the time that it's queried. The cache can change between queries.
This example displays the number of cache records that contain Kiwi in the Product field.
MsgBox Worksheets(1).PivotTables("Pivot1") _ .PivotFields("Product").PivotItems("Kiwi").RecordCount
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.