title: ActiveSheet.Paste type (Paste Only values)
body: <p>I have this simply code, I want to copy only values from WoorkBook1 into Workbook2, only values, because Workbook2 have a specific format.</p>
  
  <pre><code>Sub Test()
     Workbooks("Workbook1.xlsx").Activate
     Range("B2:B7").Select
     Selection.Copy
     Workbooks("Workbook2.xlsx").Activate
     Range("B5:B10").Select
     ActiveSheet.Paste
  End Sub
  </code></pre>
  
  <p>Tnx4all</p>