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.
>
>