Rekha,
Just try this code instead of or change it to And
With ThisWorkbook.Worksheets(Bex File)
Set rng = .Range(A1).CurrentRegion
rng.AutoFilter 15, *Chief Technology Office*, xlAnd,
*Desktop Platform*
rng.AutoFilter Field:=25, Criteria1:==*AF*
Hi Friends,
i tried piece of code for auto filter criteria , i succeeded in condition
for
autofilter for which criteria is equal to...
but does not equal to condition i am not getting proper result.
Basically i want to place a condition that 15th column in Bex file sheet
should be filter