So, I'm trying to look at the current sheet and see if AWP is anywher
on the page.
I'm using the code below, but I’m getting false positives. I check i
by searching the sheet again with the normal find and nothing come
up.

Dim rngFound As Range
Dim this As String
this = ActiveSheet.Name
Set rngFound = Sheets(this).Columns("A:U").Find(What:=awp
LookAt:=xlWhole, LookIn:=xlValues)
If rngFound Is Nothing Then
MsgBox "d'oh!"
Else
With Sheets(this)
MsgBox "Yahoo"
End With
End If

Also, I’m trying to differentiate between two types of cells. On
which has either a < or and another type that just has a =. Woul
find be the way to go and possibly confine the search to just on
cell?

Thanks for any assistance you can offer,

Chri

--
cbh3571
-----------------------------------------------------------------------
cbh35711's Profile: http://www.excelforum.com/member.php...fo&userid=3027
View this thread: http://www.excelforum.com/showthread.php?threadid=52921