| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search criteria - auto filter
Hi,
Is there another VBA way I can use to show more than 2 values to search for in a column. I would like to seacrh for 3 value in a column and show the results in the entire row. Selection.AutoFilter Field:=15, Criteria1:="=*fid*", Operator:=xlOr, _ Criteria2:="=*COLCHESTER*" I wanted to also search for a third value of Criteria3:="=*TAX-EXEMPT*" Hope that make sense. Peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Filter - capture criteria used | Excel Discussion (Misc queries) | |||
| auto filter doesn't return cells containing the custom search wor. | Excel Worksheet Functions | |||
| Auto Filter by Criteria | Excel Worksheet Functions | |||
| Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
| How do I show Auto-Filter "Search" Criteria on Sheet1? | Excel Programming | |||
Threaded Mode
