title: Copying Cells and Pasting into another workbook - 424 error
body: <p>I am trying to run a program that spits out data.  at the end of the process i want to copy that data into another workbook.  I  have it set up and working to the point that it copies and pastes the data into the other workbook but i get a 424 error on the past step.  Code Below. </p>
  
  <pre><code>sheet = Range("BL1") 
  Range("BJ3:BM12").Copy 
  
  Set wbk = Workbooks.Open("c:location")
  
  x = 1
  While wbk.Worksheets(sheet).Range("I" &amp; x) &lt;&gt; ""
      x = x + 1
  Wend
  wbk.Sheets(sheet).Range("I" &amp; x).PasteSpecial.Value   - Problem arises here
  
  Application.CutCopyMode = False
  ActiveWorkbook.Save
  Call wbk.Close(False)
  </code></pre>