Is my only option to loop through each element in the umbArr array (or
to identify each 'column' array individually, e.g. arr1, arr2 etc) and
then to loop through each element in that (e.g. arr1(1), arr1(2), etc)
-by doing something like this:

Code:
--------------------
For Each u In umbArr
For i = 1 to 10000
If umbArr(u)(i) = umbArr(u)(1) Then
NumExtreme = NumExtreme + 1
End If
Next i
Next u
--------------------

(yes I know that's an ugly code but it's just a quick example).

Anyway, is that my only option? To loop through 10000 rows for each of
the 10000 columns?? Grrr - that's precisely what I was wanting to
avoid.

Hey, can I use Case Select on arrays? Would that work better, faster,
at all??

Ahh, I'm so confused & frustrated...


--
fern
------------------------------------------------------------------------
fern's Profile: http://www.excelforum.com/member.php...fo&userid=9853
View this thread: http://www.excelforum.com/showthread...hreadid=393729