excel - VBA autofilter with multiple criteria -
excel - VBA autofilter with multiple criteria - i wondering whether help prepare next vba code. want filter rows containing entire string "color_name" , rows containing "keyword" , "size" partial string. if run macro see "color_name" , if run operator:=xland see values containing "size". thanks! activesheet.range("$a$1:$a$10000").autofilter field:=1, criteria1:=array( _ "color_name", "=*keyword*", "=*size*"), _ operator:=xlfiltervalues end sub excel vba autofilter