Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
defintion of array function | Excel Discussion (Misc queries) | |||
How to multiply all cells in array by factor | Excel Discussion (Misc queries) | |||
Transpose words and numbers into array of different proportions | Excel Discussion (Misc queries) | |||
Problem with Vlookup array selection | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |