I spelled it the way you did for the code below, but I want to point out
that you spelled "gauranteed" incorrectly (it's "ua" not "au" for the second
and third letters)...

Sub FindGAURANTEED()
Dim WS As Worksheet, R As Range
For Each WS In Worksheets
Set R = WS.Columns("B").Find("GAURANTEED", LookIn:=xlValues, _
LookAt:=xlWhole, MatchCase:=False)
If Not R Is Nothing Then
WS.Activate
R.EntireRow.Select
Exit Sub
End If
Next
End Sub

--
Rick (MVP - Excel)


"Jodie" wrote in message
...
How would I write a macro to find "Gauranteed" in any cell in Column "B"
and
then highlight that row? Also, this would be for an entire workbook.
--
Thank you, Jodie