Filter Wild Card / Contains

[grezmel]

I have the following script that isnt working correctly.

ActiveSheet.Range("$A$1:$T$12114").AutoFilter Field:=2, Criteria1:= _
"=" & Sheets("Summary").Range("C3") & "*", Operator:=xlAnd

Row C contains a list of data - example as follows :

1234
1234-b
1234-c
1234-d
1335
1445
1445-a
1445-b

I am trying to filter based on a code entered on a Summary sheet - if a user enters 1234 I would like 1234, 1234-b, 1234-c, 1234-d to display - I have tried to use "*" but it doesnt work.

Please can someone point me in the right direction.

Thanks

[NeedForExcel]

Can you attach a sample workbook?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[grezmel]

Thanks for your reply - I believe Ive solved the problem - ive changed the field type to text rather than numeric and it appears to have worked

cheers Graham