Ah, yes, didn't read it properly.

RBS


"John Keith" wrote in message
...
On Sun, 14 Sep 2008 14:10:32 +0100, "RB Smissaert"
wrote:

This works with me:

Selection.AutoFilter Field:=1, Criteria1:=SKU, Operator:=xlAnd


In this case the filter does recognize "SKU" as a variable but this
criteria is for if the cell equals the value of SKU. I need the
criteria to be contains the value of "SKU". That is why my first post
had the asterisk on either side of "SKU".

Any one else have a suggestion?



John Keith