Edit

Share via

PivotItem.RecordCount property (Excel)

  • Article

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 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.