Autofilter _ cannot assing criteria to array

[pulsar777]

Hi, I'd need to loop through criteria in filtered field.

Please Login or Register  to view this content.

When I assign multiple criteria to dynamic array, I get Type MisMatch.
When I switch to ordinary Variant ( Dim vCriteria as Variant ),
I store only the first selected Criteria.

Can somebody advise what I miss here please?

[pulsar777]

Strange is that when I have 3 and more criteria checked, it works. For less than 3 it doesn't.

[pulsar777]

Any ideas? I still haven't figured that out.
I appreciate any response.

[AB33]

When you filter data, you get visible cells. These cells are areas, not regions. Let say, rows 1 and 3 are visible, but row 2 is hidden, so when you load the data in to an array, you get areas 1, which is only 1 row, not all visible rows. Row 3 will be areas 2 and so on.

[xlnitwit]

Hi,

For 2 criteria you have values in Criteria1 and Criteria2. For more than 2 there will be an array stored in Criteria1 alone.

[pulsar777]

Thank you both!
And xlnitwit, you are completely right! That's what I was looking for.
One last, is there other way of counting how many criteria were selected than assigning array and counting its items?

[AB33]

If you are using array as a criteria, the array should have count number. Any array has dimensions.

[AB33]

I'd need to loop through criteria in filtered field.
is nothing to do with criteria in filter function.

You have already applied your criteria and got your filtered visible rows.
That is how I understood your question anyway.
Now, you are talking about the number of criteria- could only be 2 or an array criteria

[pulsar777]

Thanks AB33, both information are useful.