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.
Syntax
expression .RecordCount
expression A variable that represents a PivotItem object.
Remarks
This property reflects the transient state of the cache at the time that it’s queried. The cache can change between queries.
Example
This example displays the number of cache records that contain "Kiwi" in the "Products" field.
MsgBox Worksheets(1).PivotTables("Pivot1") _
.PivotFields("Product").PivotItems("Kiwi").RecordCount