title: Macro to copy values only from one sheet to another
body: <p>I've this VBA code </p>
  
  <pre><code>Sheets("log").Range("A125:f1000").Copy _ 
  Sheets("data").Cells(Rows.Count, "A").End(xlUp).Offset(1)
  </code></pre>
  
  <p>and it copies perfectly from sheet <code>log</code> to <code>data</code>. The only problem I'm facing is that it copies formulas with it as well whereas I only want values. I want to use same VBA code with some modifications to paste values only.</p>