This documentation is archived and is not being maintained.

Workbook.IconSets Property

Office 2007
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



Show: