XlSlicerSort enumeration (Excel)
Specifies whether items displayed in the slicer are sorted, and if they are sorted, whether they are sorted in ascending or descending order by item captions.
| Name | Value | Description |
|---|---|---|
| xlSlicerSortAscending | 2 | Slicer items are sorted in ascending order by item captions. |
| xlSlicerSortDataSourceOrder | 1 | Slicer items are displayed in the order provided by the data source. |
| xlSlicerSortDescending | 3 | Slicer items are sorted in descending order by item captions. |
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.