ReDim an array
 

Hello,

I've got an array which is 3 dimensions "tmpArray(0 To 10, 0 To 0, 0 To 0)"
and because of that I can affect directy put the result into cells in excel
using the function Range like that

ActiveSheet.Range( Cells(1,1), Cells(11,1) ) = tmpArray

is there a way to transform my 3 dimension array to one with 2 dimension or
even better an array with 1 dimension.

thanks in advance.

Nader

ReDim an array
 

Nader,
Check out Alan Beban's array functions at
http://home.pacbell.net/beban/

NickHK

"Nader" wrote in message
...
Hello,

I've got an array which is 3 dimensions "tmpArray(0 To 10, 0 To 0, 0 To
0)"
and because of that I can affect directy put the result into cells in
excel
using the function Range like that

ActiveSheet.Range( Cells(1,1), Cells(11,1) ) = tmpArray

is there a way to transform my 3 dimension array to one with 2 dimension
or
even better an array with 1 dimension.

thanks in advance.

Nader