title: VBA to paste value using Range.Copy method with Offset
body: <p>I am currently using the following code to consolidate data from Multiple sheets with the same range using Range.Copy method using Offset. </p>
  
  <p>I am trying to Paste only Values instead of formulas. But, I get the formulas also which is leading to Error "#REF!".
  Can anyone please help me with the correct syntax?
  I just started learning VBA coding.</p>
  
  <pre><code>    For Each ws In Sheets(Array("A", "B", "C", "D", "E"))
      ws.Activate
      bottomD = Range("BC" &amp; Rows.Count).End(xlUp).Row
      Range("BC3:BE" &amp; bottomD).Copy Sheets("Summary").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
      Next ws
  </code></pre>