AutoFilter with 3 or More Criteria

Good afternoon,

I am looking to create an AutoFilter that looks for multiple different beginning combinations. Please see below for code:

ActiveSheet.Range(Cells(1, 1), Cells(LastRow, LastCol)).AutoFilter Field:=13, Criteria1:=Array("56*", "57*", "59*", "62*", "67*"), Operator:=xlFilterValues

When I use the first 2 criteria the code seems to work correctly, however, when adding any more the filters returns with no results which is not correct. When I record a macro and manually select the records to include, it lists a huge array of criteria and runs properly. Is there a way to add a begins with property to the code Excel generates when recording a macro?

Thanks.

Asterisk (*) works with at most two choices. It is the same as "OR" and "AND" filter options.

Thanks for the reply. So it seems the best way to go about doing this is to do a loop and filter for 2 criteria at a time and copy and paste results? Does that seem right?

Yes,
It depends what do you want to do once you have filtered cells. If you are going to copy them to some where or delete them, You can filter 2 at a time, remove the filter, apply the next 2 again and remove filter and so on. It is the same as switching on and off the filter button.