VBA Autofilter 3 Criteria

[KptKloss]

Hi guys

not sure if it helps any people looking for a solution in the future but I used this code and it worked well for me to set up multiple criteria in separate columns:

'here is 1 criterion in column 8

ActiveSheet.Range("$B$4:$HB$3016").AutoFilter field:=8, Criteria1:="TBD"
'here are multiple criteria in column 18
ActiveSheet.Range("$B$4:$HB$3016").AutoFilter field:=18, Criteria1:=Array("Started", "On hold", "Not started"), Operator:=xlFilterValues

hope this helps someone