Workbook.ActiveSlicer Property (Excel)

Returns an object that represents the active slicer in the active workbook or in the specified workbook. Returns Nothing if no slicer is active. Read-only.

Version Added: Excel 2010

expression .ActiveSlicer

expression A variable that represents a Workbook object.

Return Value

Slicer

If you do not specify a Workbook object, this property returns the active slicer in the active workbook.

Show: