Excel.SlicerCaches.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
SlicerCaches object (Excel)	vbaxl10.chm894072	vbaxl10.chm894072	Excel.SlicerCaches	d6097f70-cdc7-3be7-575c-cf43a0765e10	04/02/2019	medium

SlicerCaches object (Excel)

Represents the collection of slicer caches associated with the specified workbook.

Remarks

Use the Item property of the SlicerCaches collection to return a SlicerCache object associated with the specified Workbook object. A SlicerCache object can be retrieved by using either the value of the Index property or the Name property of the specified object.

Example

The following code example retrieves the SlicerCache object that represents the slicer cache associated with the Country slicer.

ActiveWorkbook.SlicerCaches("Slicer_Country")

Methods

• Add

Properties

• Application
• Count
• Creator
• Item
• Parent

See also

• Excel Object Model Reference

[!includeSupport and feedback]