-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
position of the 1st element of an array found in a string
- Thread starter baucucu
- Start date
Re: position of the 1st element of an array found in a strin
Code:
Sub test()
Dim myArray, myString As String, n As Long, msg
myArray = [{"a","b","c","d","e"}]
myString = "y x q z b a"
For Each e In myArray
If InStr(1, myString, e, 1)>0 Then
msg = e
End If
n = n + 1
Next
MsgBox IIf(Len(msg)>0, msg & vbLf & n + 1, "Not Found")
End Sub
Upvote
0
arthurbr
Well-known Member
- Joined
- Dec 8, 2006
- Messages
- 2,725
- Office Version
- 365
- Platform
- Windows
Cross posting
Hi,
please read this article on cross-posting :http://www.excelguru.ca/node/7
http://www.excelforum.com/showthread.php?t=609574
Hi,
please read this article on cross-posting :http://www.excelguru.ca/node/7
http://www.excelforum.com/showthread.php?t=609574
Upvote
0
barry houdini
MrExcel MVP
- Joined
- Mar 23, 2005
- Messages
- 20,825
Richard's suggested formula doesn't actually need CTRL+SHIFT+ENTER
...although it does if you replace the array constant with a range, i.e. something like this:
=MATCH(TRUE,ISNUMBER(FIND(B1:B5,A1)),0)
...although it does if you replace the array constant with a range, i.e. something like this:
=MATCH(TRUE,ISNUMBER(FIND(B1:B5,A1)),0)
Upvote
0
Similar threads
- Question
