If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, the
SubArray function can be used for this purpose. E.g.,

Application.Max(SubArray(vData,2,4,1,5)) will return the maximum from
the values in the subarray comprised of Columns 2 thru 4, Rows 1 thru 5
of vData.

The SubArray function can be used this way to specify any contiguous
"range" of data in a 1-D or 2-D array.

Alan Beban

Sing wrote:
. . . Thank you for your reply.
There is some complication in my case.

Say I only want to find the minimum of the last 10 elements in vData. Is
Excel flexible enough to specify the start and end element of the array in
which to find the minimum?