Presence of a value in an array?

[cenkee]

hi,

I have an array like

refcode("a1","a2" etc)

I want to check if a cell's value is also a memberof this array but I couldnt find way.
I tried worksheet.match function but failed.
I need a True or False kind of an answer.



Could somebody help me please?

thank you

 

[VoG]

Try like this

Dim mtch As Boolean
mtch = IsNumeric(Application.Match(Range("A1").Value, refcode, 0))

 

[cenkee]

thanks alot, it worked