Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
find last row value in column when using MATCH to find column | Excel Worksheet Functions | |||
Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
How to find the most recent date in a column based on other column | Excel Worksheet Functions |