AutoFilter: Array as Criteria

Hey folks,

I deal with the autofilter-method in VBA for the first time and it worked quite well as long as I gave it single values as a criteria. Now I want to give it an array. First I fill the array with some weekdaynumber which works great.

The array is then wochentage(0 To 2) and contains the values (1, 2, 3). All the values exist in the corresponding column, that I want to filter (I ensure that by some more code, that I deleted for better overview).

Please Login or Register  to view this content.

The code runs, but just the entries with "3" are selected (see attached screenshot).
Unbenannt.png

What do I do wrong?

Thanks for you help!
Klaster

Try this.

Please Login or Register  to view this content.

You must specify the Operator, usually it's optional.

Or

Please Login or Register  to view this content.

Please Login or Register  to view this content.

is nothing to do with array and resizing. It uses an array as a tool for multi-selection on the same field.

Hey AB33,

I use the autofilter-method within a function. I wanted to give the "wochendtage"-array to the function so it can be used in it. Do I understand you correctly, that this is not possible?

The way you constructed does not work with auto filter, it might work with advanced filter.

You can try this way, but only one loop at a time, it does not work on multi-dimensional array

Please Login or Register  to view this content.

okay, then I'll fall back to the loop-through-array-solution. Thanks for you help!

Even if you problem is marked "Solved" perhaps this link could be of interest?

http://blog.contextures.com/archives...ia-in-a-range/

Alf

Hey Alf,
indeed naming a range with the according numbers in it might have been a solution! Won't touch my (running) solution anymore, but I'm sure your reply will be helpful for others!
Cheers,
Klaster