how to check if range contains particular word

i need to check via macro to see if range"A1:A20" contains a particular word
.. the word comes from another range via ....for each cell in range

If IsError(.Match(cell.Value, myRng, 0)) Then
'not found
Else
'found
End If


--
HTH

Bob Phillips

"Sunil Patel" <[email protected]> wrote in message
news:[email protected]...
> i need to check via macro to see if range"A1:A20" contains a particular
word
> . the word comes from another range via ....for each cell in range
>
>
>
>

if a whole word match (the cell contains only that word):

if application.Countif(Range("A1:A20"),Range("B9")) > 0 then

if not, post back.

--
Regards,
Tom Ogilvy

"Sunil Patel" <[email protected]> wrote in message
news:[email protected]...
> i need to check via macro to see if range"A1:A20" contains a particular
word
> . the word comes from another range via ....for each cell in range
>
>
>
>