SlicerCache.VisibleSlicerItems Property
Gets a SlicerItems collection that contains the collection of all the visible items in the specified slicer cache.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property VisibleSlicerItems As SlicerItems
Get
'Usage
Dim instance As SlicerCache
Dim value As SlicerItems
value = instance.VisibleSlicerItems
SlicerItems VisibleSlicerItems { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.SlicerItems
A SlicerItems collection that contains the collection of all the visible items in the specified slicer cache.
Remarks
Read-only.
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.