Is anyone aware of any Maximum or Minimum WorksheetFunction limitations when working with arrays?
I have a dataset of 240,000 datum in a worksheet...
In VBA, when I set a range (dataSet) equal to Selection and use Application.Min(dataSet) I get the correct value.
However, when I use a loop to create a copy of dataSet as an array (dataArray) and then use Application.Min(dataArray) - I get a value that is NOT the minimum of the array.
I have verified that dataArray is an exact copy of dataSet (both have 240,000 elements), but the minimum value returned from the array is not the correct value (which should be the value in array element 119975).
Bookmarks