title: VBA- Copy and pasting row on another sheet as a value
body: <p>I am moving rows from one sheet to another based on a criteria in a cell value. If the cell value is met, it moves to another sheet. However when it moves, I need it to move as values. One of my cells has a formula in it and I just want the value of that cell in the new sheet. Below is part of my code where it moves the row. My question is where do I add in the PasteSpecial or the equivalent code to move it as values? Thanks!</p>
  
  <pre><code>    For Each xCell In xRg
      If CStr(xCell.Value) = "Pipeline" Then
          xCell.EntireRow.Copy Destination:=Worksheets("Pipeline2").Range("A" &amp; B + 1)
          xCell.EntireRow.Delete
          B = B + 1
  </code></pre>