편집

다음을 통해 공유

Workbook.IconSets property (Excel)

  • 아티클

This property is used to filter data in a workbook based on a cell icon from the IconSets collection. Read-only.

Syntax

expression.IconSets

expression A variable that represents a Workbook object.

Example

In the following example, data is filtered by a cell icon.

Selection.AutoFilter Field:=1, Criteria1:=ActiveWorkbook.IconSets(xl3Arrows).Item(1), Operator:=xlFilterIcon

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.