| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for data in Excel and hide rows | Excel Worksheet Functions | |||
| del certain rows based on word search | Excel Worksheet Functions | |||
| How to search for grouped rows? | Excel Worksheet Functions | |||
| Search Columns & Rows | Excel Discussion (Misc queries) | |||
| Search Rows in a spreadsheet | Excel Programming | |||
![jt46[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
