Hi Mike,

On Error Resume Next
oCell = Cells.Find("Item")
If Not oCell Is Nothing Then
msgbox "Item found at " & oCell.Address
End If
On Error Goto 0

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mike" wrote in message
...
Hi. I have a loop where I would like to search for the
text, "Item:" within the cells. For instance, I would
want it to find "Item: 7201".

What command line should I use to find cells
containing "Item:".

Thanks,
Mike.