Need to AutoFilter based on a range of values, such as:
When the range code is inserted into the rest of the VBA code, such as:
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?
Code:
[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:
Code:
[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?