title: VBA Excel: Paste large array to range
body: <p>I'm working in VBA for excel. I have an array called "aKey" (1 by 137,000 strings but exact size is subject to change so making code generic is a neccesity). I need to paste aKey to the first column of a a worksheet. So far i have tried 
       <code>Range(.Offset(1,0),.Offset(UBound(aKey)+1,0)).Value = aKey</code> 
  but this seems to only paste 137,000 versions of the first entry of the array. 
  I have also tried 
       <code>Range(.Offset(1,0),.Offset(UBound(aKey)+1,0)).Value = WorksheetFunction.Transpose(aKey)</code>
   which also didn't work. Through a google search I did find that the Transpose function has a limited pasting size which may very well be the problem there. Does anybody know of a method to avhieve my goal? Thanks</p>