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

Name
Copy
Cut
Delete

Properties

Name
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