Re: $$Excel-Macros$$ autofilter issue

2013-06-02 Thread Rajasekhar Praharaju
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*

$$Excel-Macros$$ autofilter issue

2013-06-01 Thread rekha siri
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