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.
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
- ActiveItem
- Application
- Caption
- ColumnWidth
- Creator
- DisableMoveResizeUI
- DisplayHeader
- Height
- Left
- Locked
- Name
- NumberOfColumns
- Parent
- RowHeight
- Shape
- SlicerCache
- SlicerCacheLevel
- SlicerCacheType
- Style
- TimelineViewState
- Top
- Width
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.