SlicerCacheLevel.SortItems property (Excel)

Returns or sets the sort order of the items in the slicer. Read/write.

Syntax

expression.SortItems

expression A variable that represents a SlicerCacheLevel object.

Return value

XlSlicerSort

Remarks

The default setting of this property is xlDataSourceOrder (1).

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.