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

Community Additions

ADD
Show:
© 2014 Microsoft