VBA autofilter based on cell value

Hi,

I would like to autofilter based on a cell value using the filter "contains" as filter.

In other words if I for instance want to search for all rows in an autofilter containing the word "VBA" (as an example"), where the value "VBA" has been written in a cell. How would I do that?

I know that the code for "contains" would be

Criteria1:="=*VBA*", Operator:=xlAnd

and that the code for taken the value from a cell woud be:

Criteria1:=Range("A1").Text

So basically I need to combine the two above and are having difficulties doing it.

Can anyone help?

Thx. in advance

Lars

Not tested but try this:

Please Login or Register  to view this content.

It worked.....thank you so much..

What if I wanted to do this automatically??

i.e. I have a dropdown of words and table below the dropdown that is on autofilter. I select the word from the dropdown and the table automatically autofilters for that word -- "contains *listword* etc...


any ideas?