The original question is this (correct me if I'm wrong):
Can I have a two-dimensional array like a(5,1) and put the values of this array into a range of cells, all in one go like Range(5,1) = a.
I think the answer is no. You have to da aloop where you put individual values into individual cells.
Code:
For i=0 to 5
  For j = 0 to 1
    Cell(i,j) = a(i,j)
  Next
Next
This only being pseudocode to illustrate what I mean. I think the addressing syntax of individual cells of an excel sheet is a little different.