title: VBA Excel for Mac : Copy Paste
body: <p>A VBA macro, working in Mac Excel 2011, now yields strange results in Mac Excel 2016. Specifically in the macro below:</p>
  
  <ul>
  <li>Step 1 - opens a "portfolio", copy a range of data and close it</li>
  <li>Step 2 - activates another already opened Workbook and pastes the data there.</li>
  </ul>
  
  <p>But now, instead of data transferred in each cell, I get pasted an image with inside it all the copied data. I don't know if this comes from the copy part or the paste part.</p>
  
  <pre><code>'Step 1'
          Set WbPort(n) = Workbooks.Open(Portfolio(n))
          Sheets(1).Select
          Range("A2:O101").Copy
          Application.CutCopyMode = False
          WbPort(n).Close SaveChanges:=False
  
  'Step 2'
          WbTarget.Activate
          Sheets(1).Select
          Range("C" &amp; Range("AN" &amp; n + 2)).PasteSpecial xlPasteValues
  </code></pre>