title: Print VBA Array in to Excel Cells
body: <p>I am trying to print a VBA created array into cells of an excel spreadsheet. Percolation and Runoff values keep getting "subscript out of range" errors Am I creating hose arrays correctly? I have merged the calculation and print sub function into one.</p>
  
  <pre><code> NumMonth = 12
   Dim col As Long
   Dim rw As Long
   rw = 4
   col = 13
  
   Range(Cells(rw, col), Cells(rw + NumMonth - 1, col)).Value = _
      Application.Transpose(WC)
  
  Range(Cells(rw, col + 1), Cells(rw + NumMonth - 1, col + 1)).Value = _
      Application.Transpose(Runoff)
  
     Range(Cells(rw, col + 2), Cells(rw + NumMonth - 1, col + 2)).Value = _
       Application.Transpose(Percolation)
     End Sub
  </code></pre>