problem with find method

ganesh_05

New Member
Joined
Aug 11, 2005
Messages
43
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.
 

Forum statistics

Threads
1,078,400
Messages
5,339,991
Members
399,346
Latest member
t0land

Some videos you may like

This Week's Hot Topics

Top