| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use find() to search in the selected columns?
how to set the parameters like LookIn, Lookat or any others?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to use find() to search in the selected columns?
Try something like the following:
Dim FoundCell As Range Set FoundCell = Selection.Find(what:="something", LookIn:=xlValues, _ lookat:=xlWhole, MatchCase:=False) If FoundCell Is Nothing Then ' not found Else ' found End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "lvcha.gouqizi" wrote in message oups.com... how to set the parameters like LookIn, Lookat or any others? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
| save search settings having all tabs selected-or entire workbook | Excel Worksheet Functions | |||
| Help with a formula for concatenate and search/find with 3 columns | Excel Worksheet Functions | |||
| Search by rows and then go to selected row...in a frame? | Excel Programming | |||
| HELP,how to show search result according to specifed criteria and selected fields | Excel Programming | |||
Linear Mode
