Excel vba search in array

Vote count:

0

I need search in array

Sub f()
    Dim myArray As Variant
    myArray = Worksheets("QQ").Range("D:F")

    Dim searchTerm As String
    searchTerm = "927614*"

    'Check if a value exists in the Array
    If UBound(Filter(myArray, searchTerm)) >= 0 And searchTerm <> "" Then
        MsgBox ("Search Term SUCCESSFULLY located in the Array")
    Else
        MsgBox ("Search Term could NOT be located in the Array")
    End If
End Sub

But I get error Type mismatch. So how to lookup value with * in array?

asked 28 secs ago

user3774667

1