Thanks for prompt reply, I think I understand, will try it on Monday, as I'm
finishing for the day. Have a good weekend.

"Brtw" wrote:

I recently was looking for something like this myself. Below is what I
used to solve my problem.

If InStr(ActiveCell, SearchItem) 0 Then
' where SearchItem was a string value that I have as a user input

In the definition of InStr, the first notation is said to be [Start].
The problem I ran into was I could only get it to search one cell, and
then force it to .Offset right or down one to suit my need.

The way I understood it was that if InStr finds what its looking for it
returns a number value higher than 0, thus ' 0 ' would be necessary.