Slicers.Add Method (Excel)
Creates a new slicer and returns a Slicer object.
Version Information
Version Added: Excel 2010
Syntax
expression .Add(SlicerDestination, Level, Name, Caption, Top, Left, Width, Height)
expression A variable that represents a Slicers object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
SlicerDestination |
Required |
Variant |
A String that specifies the name of the sheet, or a Worksheet object that represents the sheet, where the resulting slicer will be placed. The destination sheet must be in the workbook that contains the Slicers object specified by expression. |
Level |
Optional |
Variant |
For OLAP data sources, the ordinal or the Multidimensional Expression (MDX) name of the level on which the slicer creation is based. Not supported for non-OLAP data sources. |
Name |
Optional |
Variant |
The name of the slicer. Excel automatically generates a name if one is not specified. The name must be unique across all slicers within a workbook. |
Caption |
Optional |
Variant |
The caption of the slicer. |
Top |
Optional |
Variant |
The initial vertical position of the slicer, in points, relative to the upper-left corner of cell A1 on a worksheet. |
Left |
Optional |
Variant |
The initial horizontal position of the slicer, in points, relative to the upper-left corner of cell A1 on a worksheet. |
Width |
Optional |
Variant |
The initial width, in points, of the slicer control. |
Height |
Optional |
Variant |
The initial height, in points, of the slicer control. |
Return Value
Slicer
Example
This example adds a SlicerCache object using the OLAP data source "AdventureWorks" and then adds a Slicer object to filter on the "Country" field.
Sub CreateNewSlicer()
ActiveWorkbook.SlicerCaches.Add("Adventure Works", _
"[Customer].[Customer Geography]").Slicers.Add ActiveSheet, _
"[Customer].[Customer Geography].[Country]", "Country 1", "Country", _
252, 522, 144, 216)
End Sub