Edit

Share via

SlicerCacheLevel.VisibleSlicerItemsList property (Excel)

  • Article

Returns the list of slicer items that are currently included in the slicer filter. Read-only.

Syntax

expression.VisibleSlicerItemsList

expression A variable that represents a SlicerCacheLevel object.

Return value

Variant

Remarks

The list of slicer items are returned as MDX unique name strings. If this list is empty, the slicer is not filtering the data source and all slicer tiles are displayed as selected.

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.