Share via

PivotCache.RecordCount Property

  • Article
Excel Developer Reference

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

Visual Basic for Applications 
  MsgBox Worksheets(1).PivotTables("Pivot1") _
    .PivotFields("Product").PivotItems("Kiwi").RecordCount

See Also