View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Display n x n array

Hi,

Iwant to take an array and put the values into excel, i tried this but it
doesn't seem to work:

For i = 1 To 3
For j = 1 To 3
t3(i, j) = Rnd
Next j
Next i

Sheets("Sheets2").Range("A2:C4").Value
=Application.WorksheetFunction.Transpose(t3)

Does anyone know how to fix this?

Thanks for your help.