title: Copy cell range from one worksheet and paste in a different worksheet as a value rather than formula
body: <p>I have this code below to copy a range of cells and paste to the next available row on a different worksheet. My issue is that it's pasting the formulas rather than the values. What do I need to change?</p>
  
  <pre><code>Private Sub CopyAuditData_Click()
  Dim ws1 As Worksheet, ws2 As Worksheet
      Dim DestRow As Long
      Set ws1 = Sheets("Call Audit Sheet")
      Set ws2 = Sheets("HiddenData")
      DestRow = ws2.Cells(Rows.Count, "A").End(xlUp).Row + 1
      ws1.Range("V1").Copy ws2.Range("A" &amp; DestRow)
      ws1.Range("V2").Copy ws2.Range("B" &amp; DestRow)
      ws1.Range("V3").Copy ws2.Range("C" &amp; DestRow)
      ws1.Range("V4").Copy ws2.Range("D" &amp; DestRow)
      ws1.Range("V5").Copy ws2.Range("E" &amp; DestRow)
      ws1.Range("V6").Copy ws2.Range("F" &amp; DestRow)
      ws1.Range("V7").Copy ws2.Range("G" &amp; DestRow)
      ws1.Range("V8").Copy ws2.Range("H" &amp; DestRow)
      ws1.Range("V9").Copy ws2.Range("I" &amp; DestRow)
      ws1.Range("V10").Copy ws2.Range("J" &amp; DestRow)
      ws1.Range("V11").Copy ws2.Range("K" &amp; DestRow)
      ws1.Range("V12").Copy ws2.Range("L" &amp; DestRow)
      ws1.Range("V13").Copy ws2.Range("M" &amp; DestRow)
      ws1.Range("V14").Copy ws2.Range("N" &amp; DestRow)
      ws1.Range("V15").Copy ws2.Range("O" &amp; DestRow)
      ws1.Range("V16").Copy ws2.Range("P" &amp; DestRow)
      ws1.Range("V17").Copy ws2.Range("Q" &amp; DestRow)
      ws1.Range("V18").Copy ws2.Range("R" &amp; DestRow)
      ws1.Range("V19").Copy ws2.Range("S" &amp; DestRow)
      ws1.Range("V20").Copy ws2.Range("T" &amp; DestRow)
      ws1.Range("V21").Copy ws2.Range("U" &amp; DestRow)
      ws1.Range("V22").Copy ws2.Range("V" &amp; DestRow)
      ws1.Range("V23").Copy ws2.Range("W" &amp; DestRow)
      ws1.Range("V24").Copy ws2.Range("X" &amp; DestRow)
      ws1.Range("V25").Copy ws2.Range("Y" &amp; DestRow)
  End Sub
  </code></pre>
  
  <p>Thanks in advance guys.</p>