Bryan,

It works fine for me. Are you sure that the item in column C doesn't have
trailing spaces in it, which would cause a mis-match.

--
HTH

Bob Phillips

"Bryan Dickerson" wrote in message
...
I'm trying to run the following Find command in VBA:

sERRow = oWkSht.Columns("C").Find(What:="eligible for rebate",
After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows,
SearchDirection:=
_
xlNext, MatchCase:=False, SearchFormat:=False).Row

Once I find the text, I need to parse out the contents of the cell, but
currently the text is not being found. I know the text is there and I
have
tried recording a macro to see what steps Excel would use. I also know
that
I lose the Intelli-Sense when I add the .Row onto it. If there's a better
way to do it, please let me know.

Thanx!

--
TFWBWY...A