Autofilter not working with Multiple And Criteria

[caabdul]

Hi, I am relatively not expert in vba so doen't understand what is happening here.

My code works for one AND criteria as follows;

Please Login or Register  to view this content.

But following does not work when I add one more AND criteria.

Please Login or Register  to view this content.

Also following not working;

Please Login or Register  to view this content.

[caabdul]

I have realized that array is way to go for more than two criteria so I am using that now. But here is what I get;

CASE 1:
I use following code:

Please Login or Register  to view this content.

which given me an error "Autofilter method of range class failed".
To resolve it I tried changing range to .Range("J" & StRw - 1) OR "Removing previous filters" but nothing works.

CASE 2:
I tried using the code;

Please Login or Register  to view this content.

which does not give any error but it ignores first 2 of the 3 criteria given in the array.

Any suggestion?

My End Result is deleting all rows except rows which contain any of Text1, Text2 or Text3 and I need it done in quickest way as data is huge.

[caabdul]

Any solution for this issue?

[jindon]

You can not use wild cards for the criteria when array used.

Try AdvancedFilter instead.