Application.Match
 

I just checked again -

the item to be matched is a Variant/String and the
array coming out of ColumnVector is also a Variant/String

The odd thing is when I do a "watch" on Column Vector I see the
folowing

(-) ColumnVector Variant/Variant(1 to
20000,1 to 1)
(-) ColumnVector(1) Variant(1 to 1)
ColumnVector(1,1) "100" Variant/String
(+) ColumnVector(2)
..
..
..



(+) ColumnVector(20000)

Is it possible that the Match is having problem because it sees the
item to be matched as a Varient/String and the columnvector as
Variant(1 to 1)