| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thanks.
thanks. I ended up with:
Function findit(strText As String) As String n = Cells(Rows.Count, "A").End(xlUp).Row For i = 1 To n v = Cells(i, 1).Value If InStr(v, strText) 0 Then strFound = v End If Next findit = strFound End Function |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search web source code for specific string | Excel Programming | |||
| Ascertaining whether a search in VBA code returns a string or a reserved word | Excel Programming | |||
| search string command to answer simple Yes or No | Excel Worksheet Functions | |||
| Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
| Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Threaded Mode
