Edit

Share via

SlicerCache.SortUsingCustomLists property (Excel)

  • Article

Returns or sets whether items in the specified slicer cache will be sorted by the custom lists. Read/write.

Syntax

expression.SortUsingCustomLists

expression A variable that represents a SlicerCache object.

Remarks

The SortUsingCustomLists property corresponds to the setting of the Use Custom Lists when sorting check box of the Slicer Settings dialog box. To access the custom lists associated with the current installation of Excel, choose the File tab > Options > Advanced, and then choose Edit Custom Lists under the General category.

The SortUsingCustomLists property only applies to slicers that are filtering non-OLAP data sources. Attempting to access this property from a slicer cache that is filtering an OLAP data source (SlicerCache.OLAP = True) generates a run-time error.

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.