Re: MS excel formula, programming, analysis, presentation and tutorials.
mga ser,
not sure if this has been asked on the previous posts pero ask lang po if it is possible to filter a column with more than two criteria tapos with wilcard.
with activesheet.cells(1, 1).currentregion
.AutoFilter Field:=1, Criteria1:="=Brian*", Operator:=xlOr, Criteria2:="=*John"
end with
that one works with two criteria, pero pano pag more than 2 na?
thanks!
mga ser,
not sure if this has been asked on the previous posts pero ask lang po if it is possible to filter a column with more than two criteria tapos with wilcard.
with activesheet.cells(1, 1).currentregion
.AutoFilter Field:=1, Criteria1:="=Brian*", Operator:=xlOr, Criteria2:="=*John"
end with
that one works with two criteria, pero pano pag more than 2 na?
thanks!