title: Paste special values from one workbook to another
body: <p>I wrote some code to copy-paste all worksheets from one workbook to another.</p>
  
  <p>I can't remove the formulas (paste special).</p>
  
  <p>I tried a lot of paste special code, nothing worked</p>
  
  <pre><code>Private Sub CommandButton1_Click()
  
  Dim sourceWB As Workbook
  Dim destWB As Workbook
  Dim sourceWBSheet As Worksheet
  Dim sheetIndex As Integer
  sheetIndex = 1
  
  Set sourceWB = Workbooks("template.xlsm") 'Asssume destination workbook is non-existent
  Set destWB = Workbooks.Add
  destWB.SaveAs "I:\PROJECT - Dashboard\2019JUNE"
  
  For Each sourceWBSheet In sourceWB.Worksheets
      sourceWB.Activate
      sourceWBSheet.Select
      sourceWBSheet.Copy Before:=destWB.Sheets(sheetIndex)
      sheetIndex = sheetIndex + 1
  Next sourceWBSheet
  
  End Sub
  </code></pre>
  
  <p>Expectation - when pasted to the destWB, only values remain (formulas are removed).</p>