Excel Macro Help

I'm working on a spreadsheet and I found a macro that copies current day information from and output page ("Data Copy") to the last empty row of a log page ("Historical Data"). This is working well, but I just realized it is copying the info into the log sheet as a reference (not plain text). So everytime I try to enter a new days data the log sheet is changed. What do i need to add to this code to have it copy as plain text to the log page (not the cell reference like it is doing now)?

Thanks!

quote:

---

Sub CopyRow() Dim lastrowSrc As Long Dim lastrowDest As Long 'Get last row of data lastrowSrc = Sheets("Data Copy").Range("A" & Rows.Count).End(xlUp).Row 'Get first blank row (last row of data +1) lastrowDest = Sheets("Historical Data").Range("A" & Rows.Count).End(xlUp).Row + 1 'Copy row Sheets("Data Copy").Range("A" & lastrowSrc).EntireRow.Copy Sheets("Historical Data").Range("A" & lastrowDest) End Sub

---