Skip to main content

ValueChange.Order property

Table of contents
  1. Syntax
  2. Return value
  3. Remarks

Returns a value that indicates the order in which this change was performed relative to other changes in the PivotTableChangeList collection. Read-only.



expression A variable that represents a ValueChange object.

Return value



The value of the Order property is automatically assigned by Excel based on the order that the user applied the changes to value cells in the PivotTable report. If multiple changes were applied in one operation, Excel will arbitrarily assign the order within that set of changes.

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>