Application.Match
Its a simplifed version of your
Application.match(11,ColumnVector(arr,1),0) and
Application.match(11,ColumnVector(arr,1))
What I'm trying to do is something like as follows:
For i = 1 to UBound(a1,1)
lb = Application.match(a1(i,1),ColumnVector(a2,1),0)
ub = Application.match(a1(i,1),ColumnVector(a2,1)
For j = lb to ub
I've already checked and the items are both strings (e.g. both "11" and
"11)
That's why I followed the ColumnVector function step by step to make
sure that both the item to be matched was a string and the column
vector was also only strings.
|