Check out is element in the array (using Filter)

[Nykyta]

I have array like next:

arr=Array("ws2","ws3","ws11")

Function to checkout is element in array is:

Function IsInArray(valToBeFound As Variant, Arr As Variant) As Boolean
IsInArray = (UBound(Filter(Arr, valToBeFound)) > -1)
End Function

When checking out "ws1" — it is found at the 3rd place in array (weird of course).
1. Is it attitude of Filter used in func IsInArray?
2. Is it global bug in arrays?
3. How to solve this problem?

Thanks in advance, Nyk.

 

[FormR]

Hi, I think it's the way filter works full stop.

You could try this alternative:

Function IsInArray(valToBeFound As Variant, Arr As Variant) As Boolean
  IsInArray = IsNumeric(Application.Match(valToBeFound, Arr, 0))
End Function

 

[ukmikeb]

deleted answer already given.

 

[Nykyta]

Thank you very much FormR. Simple but nice one.
Match returned positiion anyway. What IsNumeric do eaxtly here? Some additional checking?

 

[Nykyta]

deleted answer already given.

Thanks anyway Mike.

 

[FormR]

What IsNumeric do eaxtly here? Some additional checking?

Hi, Match() will return an error is the element is not present in the array or it's numerical position if it is. So if its a number it's in the array else it's an error and it's not.