Just to repeat RBS; MATCH() only works on a one-dimensional array. I agree HELP is not very clear about this, but still, that's
how it is


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ExcelMonkey" wrote in message ...
| What I am trying to do is redim and array. I have a 2D array with values in
| the second column. They array is sorted in descending order. I want to
| redim the array so to get rid of all rows with 0 values in the first column.
| I was using the match to find the row with the first 0 and use this to redim
| the array.
|
| Thanks
|
| EM
|
| "RB Smissaert" wrote:
|
| I don't think it works on 2-D arrays as how would it know what column to
| look in? There is no column argument in the function.
| As your array is sorted you could do a binary search or use VLookup.
|
| RBS
|
| "ExcelMonkey" wrote in message
| ...
| 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.
|
|