Advance Filter Not working Via VBA

[mayoorsubbu]

Dear All,
I am rather new to excel programming. My Advance filter code not working. . I am attaching the xlm file. Could someone tell me where i am going wrong.
Thanks

[Kaper]

Use header and value as criteria range:

Please Login or Register  to view this content.

[mayoorsubbu]

Thank u Kaper ...the macro is not fltering any record. its merely picking all records.

[Kaper]

Nope, after changing Z2 to Z1:Z2 it filters out only 16 records (out of 379) where
ProjBuildUp = PDSAS-Cap (DRDO)
It was just copying all records in case of your code with only Z2.
If you want to use also other criteria (columns V:Z) change code accordingly:

Please Login or Register  to view this content.

PS. Just to make sure you do it right - the above is a line in your code. Not whole macro.

[mayoorsubbu]

Kaper I appreciate your prompt help, but the macro does not seem to work. Is it about some settings in Excel. Thank u

[mayoorsubbu]

Its working now. Thank u

[Kaper]

Glad to hear that and thanks for marking thread as Solved and for Reputation point :-)