Using a Wild Card in an Auto Filter

[Guzzlr]

Hello All...

'**************** Build Zone 1 ********************
Sheets("Alignment").Select
With Range("B4:AG1300")
.AutoFilter Field:=12, Criteria1:="1-1"
Range("B4:AG1300").Copy
Sheets.Add(After:=Sheets(Sheets.Count)).Name = "Zone 1"
Range("A3").Select
Selection.PasteSpecial Paste:=xlPasteValues
.AutoFilter
Range("A1").Select
End With

The following code will find 1-1 for Criteria1, and is working.
My question:
What if I want to find all numbers in field 12 with numbers based upon "1-"?
For example, not only "1-1", but maybe "1-8" or maybe "1-0" etc...
How can I have a wildcard past the 1- to find all Criteria1 based upon "1-"

probably doesn't make a whole lot of sense, I don't know how to explain it...sorry
Thanks for the help

 

[Momentman]

"1-*" will work but will return all entries that start with "1-" and not discriminate numbers or text. You may want to try "1-?" for one strictly one character after the "1-"

 

[Guzzlr]

"1-*" will work but will return all entries that start with "1-" and not discriminate numbers or text.

This is working well, thank you