I am trying to use a value entered on a form by the user to use as part of an auto-filter process. The code (which isn't working!) is below:
Selection.AutoFilter Field:=13, Criteria1:="=*&TxtDescr.Value*", Operator:=xlAnd"
The code should say 'field contains' the TxtDescr.Value.
Any ideas (please!)