ExcelBanter - View Single Post

Alan Beban[_2_]

wrote:
I'm trying to use

var = Application.Match(value,arr,0) and
var2 = Application.Match(value,arr)

but I notice that when I go to type in the
formula in VBA, I'm not seeing .Match as a choice.

I don't understand the previous two lines; when you go to type in what
formula where, and where are you expecting to see .Match as a choice?

When I run the code I'm getting a type mismatch...

Thoughts?

It's difficult to tell without knowing what arr looks like and without
knowing what value is. But it might be that value in the above is
something like "11", and the Match function is looking for 11.

Alan Beban