I want to be able to do multiple search on a column but i don't want
to be restricted to the exact description. ( "York City" or
"Jersey State" or "New Jersey State")
Exp: Column 5
" New York City"
"New York State"
"New Jersey City"
"New Jersey State"

maybe if i can use "And" between words or even a " + " sign.
like: "New + State" or "New + City"
Please help!!!!
thank you
---------------------------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count 1 Then Exit Sub
If Intersect(Target, Me.Range("A4")) Is Nothing Then Exit Sub
If Me.AutoFilterMode = False Then Exit Sub

If Me.FilterMode = True Then
Me.ShowAllData
End If

If Trim(Target.Value) = "" Then Exit Sub 'after clearing filter.

Me.AutoFilter.Range.AutoFilter _
Field:=21, Criteria1:="*" & Target.Value & "*"
-------------------------------------------------------------------------------