title: copy value not formula of column vba
body: <p>I have a problem with values i try to copy...</p>
  
  <p>Let's say the value of A33 is  1655, formula for the cell is IFERROR('L-Logic'!G14;"") and when copied it displays 0 and if i cklick on that copied cell it displays the formula. why is that? Should i have to paste special values? Any suggestions?</p>
  
  <p>Am I on the right path? And if I wan't to check cells values, I was thinking to use this..</p>
  
  <p>If ws.Cells(i, 1) &lt;> "blabla" Then ws.Range("A1:A50" &amp; lastrow).Copy       Destination:=Work</p>
  
  <p>Below is my sample code. Regards</p>
  
  <pre><code>For Each Ws In Sheets(Array("List 1", "list 2", "List3"))
  
          lastrow = Ws.Range("A" &amp; Rows.Count).End(xlUp).row
  
  For i = 1 To lastRow
  If ws.cells(i, 1)&lt;&gt; "testtest" Then
  
           Ws.Range("C1:C50" &amp; lastrow).Copy Destination:=Worksheets("Master list").Range("D" &amp; lastRowMaster)
           Ws.Range("A1:A50" &amp; lastrow).Copy Destination:=Worksheets("Master list").Range("A" &amp; lastRowMaster)
          Ws.Range("L1:L50" &amp; lastrow).Copy Destination:=Worksheets("Master list").Range("B" &amp; lastRowMaster)
           Ws.Range("L1:L50" &amp; lastrow).Copy Destination:=Worksheets("Master list").Range("C" &amp; lastRowMaster)
          lastRowMaster = lastRowMaster + Range("C1:C" &amp; lastrow).Rows.Count
           Next i
  Next
  </code></pre>