excel search for left of string
Posted on 2013-01-30
I need to wire a button to search for the first string that starts with a parameter.
When I use the following, I get the first string that contains the parameter. How to I get the former (left).
Cells.Find(What:=Range("ffind"), After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _