Greetings All,

I am having difficulty understanding the
Application.Worksheetfunction.expression concept, for Arrays.

What I am trying to do is bascially the following:

vArr = Range("A1:G20") 'Read in numbers in array, vArr.

1) Get the maximum value that is in vArr in column 3 between the rows 5
and 15.
2) Get the minimum value that is in vArr in row 3 between columns 3 and
5.
3) Once the maximum value and minimum known, to tell me the cell
location of those values within vArr.

I can do the above in a worksheet, but I would like to do it in memory.

Thanks in advance.

RichardG