| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro function needed for varied searches using a data filter
I'm using a data filter to search for a specific row items so my search is
different every time. Is there a function or method that I could I (use in conjunction w\the macro below ) to input new search criteria while using this Autofilter field... This is what I have so far : Windows("Sheet1.xls").Activate Windows("Sheet2.xls").Activate Windows("Sheet1.xls").Activate Selection.AutoFilter Field:=11, Criteria1:="=" Selection.AutoFilter Field:=3, Criteria1:="=*7l54*3504*aa*", Operator:= _ xlAnd THX. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FUNCTION THAT SEARCHES DATA AND RETURNS INFO ON A DIFFERENT WORKSH | Excel Worksheet Functions | |||
| IF function that searches a range of cells for data and provide tr | Excel Worksheet Functions | |||
| Macro to insert rows at varied locations | Excel Discussion (Misc queries) | |||
| Function that searches cell for string? | Excel Worksheet Functions | |||
| Getting valid web searches and avoiding sites that contaminate web searches | New Users to Excel | |||
Linear Mode
