vba Array contains site:stackoverflow.com code example

Example: vba array contains

Dim YourArray
YourArray = Array("a", "b", "c")
Debug.Print (UBound(Filter(YourArray, "c")) > -1)   ' True