Is VBA limited to sorting certain number of array values?

[simurq]

I have a set of one-dimensional double arrays each containing thousands of members (geographic coordinates). Eg: Latitude = Array(20.356,22.369,23.568...) as Double || Longitude = Array(120.356,122.369,123.568...) as Double. When I loop through each array with WorksheetFunction.Min() / WorksheetFunction.Max() or even Application.Min() / Application.Max() to get min/max values to draw a boundary box, the results are wrong - a simple copy/paste of array values into columns A and B and MIN{A}/MAX{A} on Excel sheet (no VBA) gives completely different min/max values.

So, I wonder if VBA is limited to sorting a certain number of array values to get min/max values when the above functions are applied?!

Thanks!

 

[Jan Mach]

1. Both

WorksheetFunction.Min​

() and

Application.Min()​

represent the same:

Application.

WorksheetFunction.​

Min()

2. These functions ...Min() and ...Max() are limited.​

 

[simurq]

Jan, thanks for your prompt reply!!! I have a definite, albeit short, answer after a week of complete craziness trying to understand the problem...

Can you please elaborate on this or direct me to a source where I can learn more about the limits of arrays (my search hasn't returned any reliable source of info so far, even MS VBA Reference)? Thanks again!!!

 

[offthelip]

I never use max and min function in vba if I am looping through a range; I would calculate as you go: this code find the minumum value in column A

Sub test()
lastrow = Cells(Rows.Count, "A").End(xlUp).Row
inarr = Range(Cells(1, 1), Cells(lastrow, 1))
temp = 9.99999999999999E+307


For i = 1 To lastrow
 If inarr(i, 1) < temp Then
  temp = inarr(i, 1)
 End If
Next i
MsgBox (temp)


End Sub