Hello. I am in dire need of your help.
I am trying to reconcile two columns with names. I need to find out if names in coulmn B appear in Column A.

Here is an example

A B
Stas Neyman - Director Neyman
Will Smith, Assistant Beams
Jim Dangle, Officer Smith

As you can see, the first column contains names and titles. The second column contains only last names. The goal is to find out if any last names from coulmn B appear in anywhere in Column A.

(Imagine list of users to an application, that needs to be checked agains list of users who have been terminated)

Thank you!

Are you saying:
A********************B
Stas Neyman - Director----Neyman
Will Smith, Assistant--------Beams
Jim Dangle, Officer---------Smith
The single name is in column B and you want your function to find the single name shown in column B within the text of Column A?

Bryan

You don't say what you want to do if a name in Column B is found in Column A, but this code will turn the Column B cell yellow if the name is found (at least once) in Column A.

Sub NameFinder()
Last_B_Row = Range("B65536").End(xlUp).Row
For Each Last_Name In Range("B1:B" & Last_B_Row)
With Worksheets(1).Range("A:A")
Set c = .Find(Last_Name, lookat:=xlPart)
If Not c Is Nothing Then
Last_Name.Interior.ColorIndex = 6
End If
End With
Next
End Sub