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