Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Match" function returns wrong value
Hi,
I am trying to simply return the position of a value in an array using the "Match" function and I seem to be getting an incorrect result. I am using the following code: Sub testmatch() Workbooks("Book1").Activate MsgBox (Application.WorksheetFunction.Match("Invision", Workbooks("Book1").Sheets("Sheet1").Range("A:A"))) End Sub "Invision" is in row 9 of column A. However, the MsgBox displays 284. There are entries in rows 2 through 363 if that is of any help. I would be very grateful for any assitance you could provide. I am using Visual Basic 6.3 and MS Excel 2003 SP2. Thanks. Darrell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!! | Excel Worksheet Functions | |||
Multiple Offset/Match formula returns "#N/A" | Excel Discussion (Misc queries) | |||
Finding cell that returns bad "solver_val" function. | Excel Discussion (Misc queries) | |||
SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx | Excel Worksheet Functions | |||
Excel "mode" function returns different results based on sort orde | Excel Worksheet Functions |