E
ExcelMonkey
What is wrong here? I have a 2D array. The following gives me an error say
it can't find Match property. I am trying to locate first row with 0 in a
sorted array (high to low)
MaxRow = Application.WorksheetFunction.Match(0, ConsFunctionArray, 1)
Yet I know that my first zero value occurs in row 5 of the second dimension
in hte 0-based array
?ConsFunctionArray(4,1)
0
As such I am expectinge th results to give me a 4 above.
it can't find Match property. I am trying to locate first row with 0 in a
sorted array (high to low)
MaxRow = Application.WorksheetFunction.Match(0, ConsFunctionArray, 1)
Yet I know that my first zero value occurs in row 5 of the second dimension
in hte 0-based array
?ConsFunctionArray(4,1)
0
As such I am expectinge th results to give me a 4 above.