Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Min Function on 2D Array
Can't seem to get this to work. I am trying to calculate the min value for
the second column in an array. The printout from my Immediate Window tells me this value should be 2. However the following line returns a value of 1: MinRow = Application.WorksheetFunction.Min(Array1, 2) Sub MakeSenseOfArrays() Dim Array1 As Variant Dim MinRow As Integer ReDim Array1(0 To 1, 0 To 2) Array1(0, 0) = 1 Array1(0, 1) = 2 Array1(0, 2) = 3 Array1(1, 0) = 10 Array1(1, 1) = 20 Array1(1, 2) = 30 For X = 0 To UBound(Array1, 1) Debug.Print Array1(X, 0) & " " & Array1(X, 1) & " " & Array1(X, 2) Next MinRow = Application.WorksheetFunction.Min(Array1, 2) End Sub Immediate Window: 1 2 3 10 20 30 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array / Function HELP!!! | Excel Worksheet Functions | |||
OR function in array-entered IF function | Excel Worksheet Functions | |||
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) | Excel Programming | |||
need some help with an array function | Excel Discussion (Misc queries) | |||
Help with an array function | New Users to Excel |