Workbook.IconSets Property

  • Article
Excel Developer Reference

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

Version Information
 Version Added:  Excel 2007

Syntax

expression.IconSets

expression   A variable that represents a Workbook object.

Example

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

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

See Also