Find Small in and Array

[jumpbackjack]

I'm trying to find the first Small number in a one dimensional array as shown below. I'm trying to use SortArray() to define that range. Is this not possible? If so, how can I sort an array. Thanks.


L = WorksheetFunction.Small(SortArray(1), SortArray(4), 1)

[mancubus]

this may give you an idea:

MsgBox Application.Small(Array(1, 10, 45, 5, 60, 7, 9), 5)

the result is 10, which is the 5th smallest number in the array.

[p45cal]

Not at all sure what you're trying to do but you might get more joy using Application rather then WorksheetFunction, especially if you're using an array as the 2nd argument of the Small function:
30710