Is it impossible to AutoFilter based on a range of values?

[Eric G]

Need to AutoFilter based on a range of values, such as:

[LEFT][COLOR=#000000][FONT=Calibri]Worksheets("Sheet2").Range("A1:A5").Value[/FONT][/COLOR][/LEFT]

When the range code is inserted into the rest of the VBA code, such as:

[COLOR=#222222][FONT=Calibri][SIZE=3][COLOR=#000000]Worksheets("Sheet1").Range("$A$5:$C$100").AutoFilterField:=2, Criteria1:=Worksheets("Sheet2").Range("A1:A5").Value[/COLOR][/SIZE][/FONT][/COLOR]

The code filters only for the value in A5. The remaining values in the range are ignored.

Any ideas on how to AutoFilter based on a range of values?

 

[Fluff]

How about

Dim ary As Variant
ary = Worksheets("Sheet2").Range("A1:A5").Value
Worksheets("Sheet1").Range("$A$5:$C$100").AutoFilter 2, Application.Transpose(ary), xlFilterValues

 

[Eric G]

How about

Dim ary As Variant
ary = Worksheets("Sheet2").Range("A1:A5").Value
Worksheets("Sheet1").Range("$A$5:$C$100").AutoFilter 2, Application.Transpose(ary), xlFilterValues

You're a Godsend. Where did you learn all of this stuff??? Incredible. Thanks, Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.

I learnt most of what I know from this wonderful site

 

[DanteAmor]

I don't think so, I think Fluff was born with all that wisdom ray:

 

[Fluff]

Nice of you to say so, but I consider myself to be an enthusiastic amateur and have learnt a formidable amount (either directly or indirectly) from a lot of the other members here.