title: Copy Entire Row (Values not formulas) VBA
body: <p>I need to copy rows between multiple worksheets and while I managed to do that it only copies the formulas and not the values. I haven't used VBA for years and I just can't think of how to do it.</p>
  
  <p>My existing code is: </p>
  
  <pre><code>Workbooks.Open filename:=NewFN
      filename = Mid(NewFN, InStrRev(NewFN, "\") + 1)
  
  
          For i = 1 To 14
              Workbooks(filename).Sheets("sheet1").Rows(i).Copy ThisWorkbook.Sheets("BD Raw Data").Rows(insertRow)
  
              insertRow = insertRow + 1
          Next i
  
          Workbooks(filename).Close SaveChanges:=False
  </code></pre>