title: Pasting errors in Excel 2013 VBA
body: <p>I have a VBA script that combines data from a bunch of Excel files and presents the results neatly.
  It does this by opening an input file, copying the required range of data, and pasting it into the results file, repeatedly.</p>
  
  <p>We just upgraded to Office 2013, and some of the pastes are going to the wrong locations, for example:</p>
  
  <pre><code>  Workbooks(currentBook).Sheets("InputList").Range("E1:F1000").Copy
    ThisWorkbook.Sheets("Results").Range("B2").PasteSpecial Paste:=xlPasteValuesAndNumberFormats
  </code></pre>
  
  <p>is not pasting to cell B2 but rather to J1.</p>
  
  <p>Another copy-paste operation which should give:</p>
  
  <pre><code>Location    Date    Value
  Location    Date    Value
  Location    Date    Value
  </code></pre>
  
  <p>by executing this code:</p>
  
  <pre><code>Workbooks(currentBook).Sheets("Pay").Range("B1:B2").Copy
  ThisWorkbook.Sheets("Problem Sheets").Range("E1").PasteSpecial Paste:=xlPasteValuesAndNumberFormats
  ThisWorkbook.Sheets("Problem Sheets").Range("E1:E2").Copy
  ThisWorkbook.Sheets("Problem Sheets").Range("A" &amp; problemCell).PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Transpose:=True
  ThisWorkbook.Sheets("Problem Sheets").Range("E1:E2").ClearContents
  problemCell = problemCell + 1
  </code></pre>
  
  <p>is instead ending up with:</p>
  
  <pre><code>Location    Location   Value
  Location    Location   Value
  Blank       Blank      Value
  </code></pre>
  
  <p>I would really appreciate any assistance with understanding and dealing with this behaviour - I need to be able to trust the results in this file, and in Office 2010 I could!</p>