Copying Data from one Workbook to a different workbook - Values only

[tlaltmey]

I have the following lines of code:

'Finds the last used row based on Column B and places it in the last empty row of Column A in the Log File
lDestLastRow = wsDest.Cells(wsDest.Rows.Count, "A").End(xlUp).Offset(1).Row

wsCopy.Range("G1").Copy _
    wsDest.Range("A" & lDestLastRow)

This copies the data from G1 of the first workbook and places it in the A column of the 2nd workbook. Is there a quick way to ensure that this does not paste the formula found in G1 and instead pastes the raw data value?

Thanks

 

[GWteB]

Don't copy the source range in its entirety, just take it's value and assign it to the destination range's value:

wsDest.Range("A" & lDestLastRow).Value = wsCopy.Range("G1").Value