I am writing a program in Excel Macro, where I need to create an array and then have to check wheather an element exists or not in that array.
I have created the array as follows -
Dim tmpArr(1 to 10) as Integer
tmpArr = Array(2,4,6,8,10)
Now, i can't find any clue how to check a value 5 is exists in the array or not.