Autofilter using Array & loop

[Faridwahidi]

Hi,

can anyone help me so that it works.

Please Login or Register  to view this content.

[Vikas_Gautam]

try this....

Please Login or Register  to view this content.

Don't forget to click *

[Faridwahidi]

hi vikas,

There is no difference with my original post. at which point you make correction?,

I want the filter to display all sCriteria.

[GIS2013]

Farid,

When you're looping, don't you want to copy the results of the each loop?

Secondly, consider using the XlAutoFilterOperator, unless you're looking for values which meet both criteria, for instance (for loop 1) both "Business Banking" (in column 2) and "BC, HEA*" (in column 6).

[Faridwahidi]

Hi GIS2013,

how to copy the result of each loop?

[nilem]

Hi Faridwahidi,
maybe something like this

Please Login or Register  to view this content.

[GIS2013]

I'm sure all the solutions you've got here are good, I tried to remain with your code structure.

Check the file, you'll to make your adjustments.

[Faridwahidi]

Hi nilem,

Thanks a lot. Your code working fine. for me, it is quite tough to understand this part. if possible, can you explain to me?

Please Login or Register  to view this content.

GIS2013 ,
Your code has error while running on .AutoFilterMode = False

[GIS2013]

Fixed it, hope it may still help.