Hello
I am wondering if the AutoFilter when used with Array of fields using wildcards has some limitation. In example below, if I use two entries in my AutoFilter, the filtering works fine but if I use a third entry, the "4-*" here, the filtering is not working anymore.
I suspect Excel is limiting to two entries as when using textual filter from the menu.
Could someone confirm my statement ?
<colgroup><col style="width:66pt" width="88"> </colgroup><tbody>
</tbody>
Sub test()
Range("A1").Select
Selection.AutoFilter Field:=1, Criteria1:=Array("1-*", "2-*", "4-*"), _
Operator:=xlFilterValues
End Sub
I am wondering if the AutoFilter when used with Array of fields using wildcards has some limitation. In example below, if I use two entries in my AutoFilter, the filtering works fine but if I use a third entry, the "4-*" here, the filtering is not working anymore.
I suspect Excel is limiting to two entries as when using textual filter from the menu.
Could someone confirm my statement ?
ColumnA |
1-one |
1-oneb |
2-two |
2-twob |
3-three |
3-threeb |
4-four |
<colgroup><col style="width:66pt" width="88"> </colgroup><tbody>
</tbody>
Sub test()
Range("A1").Select
Selection.AutoFilter Field:=1, Criteria1:=Array("1-*", "2-*", "4-*"), _
Operator:=xlFilterValues
End Sub