Edit

Share via

ValueChange.Order property (Excel)

  • Article

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

Syntax

expression.Order

expression A variable that represents a ValueChange object.

Return value

Integer

Remarks

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.

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.