title: VBA paste as values - how to
body: <p>I have some VBA code that copys a range from one sheet and then pastes it to another at the first blank line.  What it is copying are vlookup formulas so when it pastes it pastes all 0's, how would I go about getting it to paste what it copies as values so the results are retained?  </p>
  
  <p>Code:</p>
  
  <pre><code>Private Sub PasteChartDataQtyCompare()
  'This step pastes the range of values to the chart data tab
      Sheets(1).Range("A6:J22").Copy _
      Destination:=Sheets("Chart Data").Cells(Sheets("Chart Data").Rows.Count, 1).End(xlUp).Offset(1, 0)
  End Sub
  </code></pre>
  
  <p></p>