Hello everyone
I have values in range("C5:G5") .. and I need to build UDF that searches specific value in this range but range C5:G5 is stored as an array



Example:
The values in range("C5:G5") are 13 / 22 / 33 / 34 / 47

arrTemp=range("C5:G5").value

The value to search is 34

I imagine the following UDF
SearchInAnArray(the value{34},arrTemp)

The result in that case would be True as the value 34 existing the array arrTemp

Thanks advanced for help