title: Pasting range vba in values without using clipboard
body: <p>I am trying to copy and paste a range in values without using the clipboard, below code works but doesn't copy in values (includes forumlas etc):</p>
  <p>any ideas as how to make this work?</p>
  <pre><code>NbRowsPnLD1 = PnLD1WS.Range(&quot;A1&quot;).End(xlDown).Row
  PnLD1WS.Range(PnLD1WS.Cells(1, 1), PnLD1WS.Cells(NbRowsPnLD1, 228)).Copy(PnLD2WS.Cells(1, 1)).PasteSpecial xlPasteValues
  </code></pre>