SlicerCacheLevels.Item Property (Excel)
Returns the specified SlicerCacheLevel object from the collection, or if no level is specified, returns the first SlicerCacheLevel object in the collection.
Version Information
Version Added: Excel 2010
Syntax
expression .Item(Level)
expression A variable that returns a SlicerCacheLevels object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Level |
Optional |
Variant |
The MDX unique name of the level or index number of the object. |
Example
The following example retrieves a SlicerCacheLevel object that represents the Country level of the Customer Geography hierarchy from the SlicerCacheLevel collection of the Country slicer.
ActiveWorkbook.SlicerCaches("Slicer_Country"). _
SlicerCacheLevels("[Customer].[Customer Geography].[Country]")