Set autofilter criteria with VBA from a range

I'm trying to set the criteria for an autofilter using VBA. I would like the values to come from a list on a separate sheet. So I have the autofilter on Sheet1 A:K and would like to set the criteria in column A to match all entries in column A of sheet 2, which will be a dynamic range. This is what I have pieced together and can't seem to get any further.

Please Login or Register  to view this content.

Works perfectly! Thank you!