title: Copy and paste excel range between workbooks in powershell
body: <p>I am trying to copy and paste an excel range between two workbooks, but the copy function is not working as I intend.
  Observe the following code snippet.</p>
  
  <pre><code>$worksheetCSV.activate()
  $range1=$worksheetCSV.Range("a","h")
  $worksheetCSV.copy($range1)
  
  $worksheetXLS.activate()
  $lastRow = $worksheetXLS.UsedRange.rows.count + 1
  $range2=$worksheetXLS.Range("A" + $lastrow)
  $worksheetXLS.Paste($range2)
  </code></pre>
  
  <p>This code almost works but the only cell which is pasted is:</p>
  
  <pre><code>$worksheetXLS.Paste($range2)
  </code></pre>
  
  <p>Is there any way which I can copy the actual contents of the range to be pasted.</p>