range with an autoFilter. application | |
count | |
creator | |
criteria1 and criteria2 | Values that are used for filtering. If criteria2 is used, operator defines how they're related to one another. |
on | Boolean which indicates if this filter is applied to the range or not. In order for criteria1, criteria2 and operator to have a value, on needs to be true. |
operator | |
parent |
Name | Value | Description |
xlAnd | 1 | Logical and of criteria1 and criteria2 |
xlBottom10Items | 4 | Lowest-valued items displayed (number of items specified in criteria1) |
xlBottom10Percent | 6 | Lowest-valued items displayed (percentage specified in criteria1) |
xlFilterCellColor | 8 | Color of the cell |
xlFilterDynamic | 11 | Dynamic filter |
xlFilterFontColor | 9 | Color of the font |
xlFilterIcon | 10 | Filter icon |
xlFilterValues | 7 | Filter values |
xlOr | 2 | Logical or of criteria1 or criteria2 |
xlTop10Items | 3 | Highest-valued items displayed (number of items specified in criteria1) |
xlTop10Percent | 5 | Highest-valued items displayed (percentage specified in criteria1) |
criteria1 and criteria2 can be assigned strings whose interpretion is as follows: >, <, >= and <= find values that are greater or smaller (or equal) than a given value. For example ">500" or ">nm".
<> finds values that are not equal to a given value.
criteria1 to "foo*" finds text that starts with foo, setting it to "z*e" finds text that starts with z and ends with e etc.
<>: "<>*foo*" finds values that don't contain foo.
operator to xlFilterValues and assigning an array to criteria1: criteria1 = array("foo", "bar", "baz")