Slicer Object (Excel)
Represents a slicer in a workbook.
Version Added: Excel 2010
Each Slicer object represents a slicer in a workbook. Slicers are used to filter data in PivotTable reports or OLAP data sources.
Use the Add method to add a Slicer object to the Slicers collection. To access the SlicerItem object that represents the currently selected button in a slicer, use the ActiveItem property of the Slicer object.
The following code example changes the caption for the first slicer in the first slicer cache to "My Slicer".
ActiveWorkbook.SlicerCaches(1).Slicers(1).Caption = "My Slicer"
The following code example sets the width of the first slicer in the first slicer cache to equal 200 points.
ActiveWorkbook.SlicerCaches(1).Slicers(1).Width = 200