You can use the worksheet function Index:
Did you mean the worksheet function Match?
--
Regards,
Tom Ogilvy
"Dave Peterson" wrote in message
...
You can use the worksheet function Index:
Option Explicit
Sub testme()
Dim res As Variant
Dim MyArray As Variant
MyArray = Array("Test", "This")
res = Application.Match("this", MyArray, 0)
If IsError(res) Then
MsgBox "Not in there"
Else
MsgBox "It's there and at position: " & res
End If
End Sub
Luis Carrion wrote:
Hi,
If I were to check if a variable: A="Test" is inside a list of
possible strings,Iīll do this:
Dim A as string
Dim B as variant
Dim MyArray As variant
MyArray=Array("Test", "This")
For Each B in MyArray
If A=B then Msgbox "Itīs inside the group
Next A
Is it possible to test this in other way; something like this
If A is in/like MyArray then....... ---without looping inside the
array
Thanks.
LC
--
Dave Peterson