hii frnds
I am searching for a string "q".
I want to search it only in column "A" but when i use the following code... it is also searching in other columns. how to avoid this problem? any idea?
Set r = .Cells.Find(what:=q, after:=Range("A1"), LookIn:=xlFormulas, _
lookat:=xlPart, searchOrder:=xlByRows, _
searchdirection:=xlNext, MatchCase:=False)
Thank you.
I am searching for a string "q".
I want to search it only in column "A" but when i use the following code... it is also searching in other columns. how to avoid this problem? any idea?
Set r = .Cells.Find(what:=q, after:=Range("A1"), LookIn:=xlFormulas, _
lookat:=xlPart, searchOrder:=xlByRows, _
searchdirection:=xlNext, MatchCase:=False)
Thank you.