Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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: