SlicerCache.VisibleSlicerItems Property (Excel)
Returns a SlicerItems collection that contains the collection of all the visible items in the specified slicer cache. Read-only
Version Information
Version Added: Excel 2010
Syntax
expression .VisibleSlicerItems
expression A variable that represents a SlicerCache object.
Return Value
SlicerItems
Remarks
The VisibleSlicerItems property is only applicable for slicers that are based on PivotTables based on workbook ranges or lists (SlicerCache.SourceType = xlDatabase). Attempting to access the VisibleSlicerItems property for slicers that are connected to an OLAP data source (SlicerCache.OLAP = True) generates a run-time error.