title: How to copy a worksheet to a new worksheet but as values only?
body: <p>I copy a worksheet "Costing Sheet" to a new worksheet.</p>
  
  <p>I use this code:</p>
  
  <pre><code>Sub CopyPasteSheetAsValues()
      Worksheets("Costing Sheet").Copy After:=Worksheets("Costing Sheet")
      Application.CutCopyMode = False
  End Sub
  </code></pre>
  
  <p>There are formulas in the copied sheet that I do not need in the new worksheet. I would like to copy the worksheet into a new sheet but paste as 'values only'.</p>
  
  <p>I also have the code below that can copy and paste the worksheet but it overrides the current sheet. Instead of a new worksheet with values only, it's the same worksheet as values.</p>
  
  <pre><code>Sub CopyPasteSheet()
      'Copy and Paste Summary Sheet as Values
      Sheets("Costing Sheet").Cells.Copy Before:=Sheets("Comparison Job")
      Sheets("Costing Sheet").Cells.PasteSpecial Paste:=xlPasteValues
      Application.CutCopyMode = False
  End Sub
  </code></pre>
  
  <p>I tried to combine the codes but was unsuccessful.</p>