영어로 읽기

다음을 통해 공유


SlicerCache.VisibleSlicerItems Property (Excel)

Returns a SlicerItems collection that contains the collection of all the visible items in the specified slicer cache. Read-only

Version Information

추가된 버전: Excel 2010

Syntax

.VisibleSlicerItems

A variable that represents a SlicerCache object.

Return Value

SlicerItems

Remarks

The VisibleSlicerItems property is only applicable for slicers that are based on PivotTables based on workbook ranges or lists (SlicerCache.SourceType = xlDatabase). Attempting to access the VisibleSlicerItems property for slicers that are connected to an OLAP data source (SlicerCache.OLAP = True) generates a run-time error.

참고 항목

개념

SlicerCache Object Members

SlicerCache Object