title: Excel VBA - write new rows to existing array
body: <p>I have no clue how to do this so any help will be awesome. Using an array, I send row by row to an excel workbook, which does numerous calculations (too many to be programmed) and spits out 13 values which I want to store into another array. Is this possible?</p>
  
  <pre><code>Dim aP() as Variant
  Dim wbR as Workbook
  Dim wsR as Worksheet
  Dim i as Long
  
  Set wbR = Workbooks.Open([directory])
  Set wsR = wbR.Sheets("Sheet1")
  aP = Application.Transpose(Activesheet.Range("A1:Z100"))
  For i = 1 to 100
  wsR.Range("A1:A26") = Application.Index(aP, [row(1:26)], i)
  'this is where I need help. Want to paste range C1:C13 into another array,
  'so that I can paste it back into the activesheet. I do not wish to paste it 
  'straight back to the worksheet, but accumulate all the data into array and 
  'and then paste the array into the activesheet
  Next i
  
  Exit Sub
  </code></pre>