Slicer Object (Excel)
Represents a slicer in a workbook.
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".
The following code example sets the width of the first slicer in the first slicer cache to equal 200 points.