Syntax for Finding Min of Multi-Dimensional Array

[biocentrism]

Hello

I have a an array (virtual not a range on a sheet) that has 2 dimensions.

I would like to find the minimum value of the first column.

I have tried the code below and get a 'subscript out of range' error.

MinValue = Application.Min(arrPrices(0, 1))

Any ideas?

Thanks.

 

[Domenic]

Try...

With Application
    MinValue = .Min(.Index(arrPrices, 0, 1))
End With

Note that the array cannot exceed more than 65,536 rows, otherwise an error occurs.

Hope this helps!

 

[biocentrism]

Try...

With Application
    MinValue = .Min(.Index(arrPrices, 0, 1))
End With

Note that the array cannot exceed more than 65,536 rows, otherwise an error occurs.

Hope this helps!

This worked perfectly! Thank you very much Domenic.

 

[Domenic]

You're very welcome!