![]() |
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. |
All times are GMT +1. The time now is 02:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com