Skip to main content

PivotCache.RecordCount property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

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

MsgBox Worksheets(1).PivotTables("Pivot1") _

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>