Thread: ReDim an array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nader Nader is offline
external usenet poster
 
Posts: 44
Default 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