filtering data with a variable

  • Thread starter Thread starter john.9.williams
  • Start date Start date
J

john.9.williams

i wish to filter a list by using the contains option, but i want to
filter with contains a varible with its cell, then return the filtered
result, cell a only to another part of my sheet, can this be done.

example

Selection.AutoFilter Field:=1, Criteria1:="=*test*", Operator:=xlAnd

i want to replace test with a variable name, I have tried removing the
speech marks but cannot seem to get it right, any help greatly
recieved

johny
 
Back
Top