title: Paste method of worksheet class failed
body: <p>Please consider the following Excel VBA code</p>
  
  <pre><code> Private Sub Copy_Formula(Dest As Integer, iCustomer As Long)
    Sheets("INPUT").Select
    Cells(2, Dest).Select
    Selection.Copy
    Range(Cells(4, Dest), Cells(3 + iCustomer, Dest)).Select
    ActiveSheet.Paste '&lt;------ Errors out
    Application.CutCopyMode = False
    Calculate
    Range(Cells(4, Dest), Cells(3 + iCustomer, Dest)).Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False
   End Sub
  </code></pre>
  
  <p>When this sub is called, value of Dest is 84 and iCustomer is 1044770.</p>
  
  <p>I was just wondering if there is a solution to solve this paste operation? Is it possible to increase the buffer size somewhere to accommodate this massive data? We are using 32 bit Excel 2010 on a 32 GB RAM machine with a 64 bit OS.</p>
  
  <p>Would a 64 bit Excel work?</p>