Excel VBA advanced filter criteria range does not work

**Distrooooy** · 08-14-2017, 08:40 PM

I am doing a project one code involves filtering a 500000*3 of cells with criteria range of about 60. Its filtered by date.

But, the criteria range does not work, and it wont filter. When I change the criteria range to a smaller one sometime it might work.

What might be the reason?

Here is the code:

SRange.AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=FRange, Unique:=False

I the criteria range is dynamic and random so I guess I have to stick with the advanced filter

First time poster, any help is appreciated

**humdingaling** · 08-14-2017, 09:01 PM

what is the criteria?

**scottiex** · 08-14-2017, 09:16 PM

code looks OK (although that is a fair bit of filtering).
I got it to run on a couple of ranges that I set up for Srange and Frange (big like yours).
You should upload a file so we can see it in use.

**humdingaling** · 08-14-2017, 09:22 PM

create the exact same setup
500000x3 columns + 60 individual criteria
works no problems....albeit a rather large file size (13mb)

**Distrooooy** · 08-15-2017, 01:27 AM

Thanks for the kind help guys, its seems odd to me as well because it should work perfectly. Can anyone show me how to upload excel files so we can take a closer look of the issue?

I go to the advanced reply but the attachment feature does not work (its a blank broken box).