Find a value in a column
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
|