Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Match
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
application.match and value problem | Excel Discussion (Misc queries) | |||
application.match | Excel Discussion (Misc queries) | |||
Application.Match | Excel Programming | |||
Application.Match | Excel Programming | |||
Application.Match with Times | Excel Programming |