autofilter display data more than 2 values

[MaartenRo]

Hi,

I am writing a macro that displays the data for the values: "CD", "DGFZ", "DGRB" and "DGFZ". However, if i add more than 2 values the macro won't work. How can i add two values to the code and let the macro show the right data?
This macro works but only for 2 values and not 4.

Please Login or Register  to view this content.

Any input is much appreciated!

[jindon]

You can use Array like

Please Login or Register  to view this content.

[MaartenRo]

Works perfect. Thanks.