Slicer.SlicerCacheType (Excel)

Returns the type of the slicer cache: slicer (xlSlicer) or timeline (xlTimeline) . Possible return values are xlSlicer - Slicer cache represents a Slicer, xlTimeline - Slicer cache represents a Timeline.


Dim xscSlicerCacheType As XlSlicerCacheType
xscSlicerCacheType = ActiveWorkbook.ActiveSlicer.SlicerCacheType