filtering data with a variable

[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

 

[Dave Peterson]

Selection.AutoFilter Field:=1, Criteria1:="=*" & yourvariablenamehere & "*"