VBA Like Operator

[Philippe27]

Basically I want to look in the 5th column and Sheet14 and find all the names that match the names in the 1st column of Sheet1

My problem is the names do not match exactly.
I know the Like operator will return True for:
AAA Like "*A*"
but my problem in in my case the A is a variable I get from a specific cell and I have about 40 of those that I need to look up and none are exact matches with the other list.

Is there any way to do this that is relatively simple as I'm a beginner with VBA.
Thanks
Phil

 

[Andrew Poulsom]

You can use variables with the Like operator. I pu Andrew in A1 and ndre in A2. This returned True:

Sub Test()
    Dim Whole As String
    Dim Pattern As String
    Whole = Range("A1").Value
    Pattern = Range("A2").Value
    MsgBox Whole Like "*" & Pattern & "*"
End Sub

You may also find this helpful:

http://www.mrexcel.com/board2/viewtopic.php?p=974873#974873

 

[Philippe27]

Great it's working, thanks

 

[oprea1991]

Thanks a lot!