Slicer object (Excel)

Represents a slicer in a workbook.

Remarks

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.

Example

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

Methods

• Copy
• Cut
• Delete

Properties

• ActiveItem
• Application
• Caption
• ColumnWidth
• Creator
• DisableMoveResizeUI
• DisplayHeader
• Height
• Left
• Locked
• Name
• NumberOfColumns
• Parent
• RowHeight
• Shape
• SlicerCache
• SlicerCacheLevel
• SlicerCacheType
• Style
• TimelineViewState
• Top
• Width

See also

• Excel Object Model Reference

Support and feedback

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.