I have populated a two dimensional array with values from a range of cells on a worksheet. However, I would like to output that array as a single row. I have tried the following code, which arranges the new array properly, but prints out a blank range of values.
Dim IMArray()
IMArray() = Sheets(1).Range("I5:T6").value
Dim IArr(1, 1 To 24)
For i = 1 To 12
For j = 1 To 2
IArr(1, 2 * i + j - 2) = IMArray(j, i)
Next j
Next i
Sheets(2).Range("A1:X1").value = IArr()
What should I do to fill the range with the desired values?
Bookmarks