No; but if the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, the coding
can look simpler (the looping is within the function):
Replace the loop with
If ArrayCountIf(MyArray, A) 0 Then _
MsgBox "it's there" Else MsgBox "it's not"
Alan Beban
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