search rows
 

Is anyone know how to search rows from a texbox data given and it wil
return a row result? Thanks for your help.

Joh

--
jt4
-----------------------------------------------------------------------
jt46's Profile: http://www.excelforum.com/member.php...fo&userid=1515
View this thread: http://www.excelforum.com/showthread.php?threadid=26982

search rows
 

Dim rng as Range, rng1 as Range
set rng = Cells.find(Userform1.Textbox1)
if not rng is nothing then
set rng1 = rng.entirerow
End if

--
Regards,
Tom Ogilvy

"jt46" wrote in message
...

Is anyone know how to search rows from a texbox data given and it will
return a row result? Thanks for your help.

John


--
jt46
------------------------------------------------------------------------
jt46's Profile:
http://www.excelforum.com/member.php...o&userid=15154
View this thread: http://www.excelforum.com/showthread...hreadid=269823