"Alan Beban" wrote in message
...
In xl2000 I get a Type mismatch error from Set arrIn = Nothing; not
unexpected, since arrIn is not an Object variable. When I comment that
line out it works fine, as it does if I substitute Erase arrIn for Set
arrIn = Nothing.


I wasn't erring out on the line 'Set arrIn = Nothing' but rather getting an
out of memory message on 'ReDim arrOut(intLowerj To lngUpperJ, intLoweri To
lngUpperI)'. Nevertheless I took up your good suggestion of using 'Errase
arrin' but it didn't solve the problem. Looks to me like the issue is that
there isn't enough memory to support two arrays of this large size - hence
my thought about transposing over in chunks.

Thanks,
Wayne C.