Dim blnThere As Boolean
blnThere = (InStr(1, Range("T1").Value, Range("A1").Value, vbTextCompare) 0)
MsgBox blnThere
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"DaveM"
wrote in message
Hi
Sheet1, Column A as Names in the cells as in A1 John Smith, A2 Joe Brown
etc.
In Column T there is the same name in each row, yet the name is in a
Sentence.
How is a good way of checking the cells have the same name in each row.

A1 John Smith - T1 John Smith was out today (could have text here)

A2 Joe Brown - T2 Joe Brown was in today (could have text here)

A3 Albert Jones - T3 New Albert Jones on holiday (could have text here)

Etc
Thanks in advance
All the best
Dave

Thought for the Day:
"There are many ways of going forward, but only one way of standing still."
Franklin D. Roosevelt