VBA to Paste Values not Formulas.

Hi, I currently have this formula

Private Sub CommandButton2_Click()
Dim ws1 As Worksheet, ws2 As Worksheet
Dim DestRow As Long
Set ws1 = Sheets("Month Template")
Set ws2 = Sheets("Development Plan Log")
DestRow = ws2.Cells(Rows.Count, "A").End(xlUp).Row + 1
ws1.Range("x3").Copy ws2.Range("A" & DestRow)
ws1.Range("p27").Copy ws2.Range("B" & DestRow)
End Sub

However it pastes the formulas and I just want it to paste the values. Can you please advise how I would achieve this?

Thanks
Hayley

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Change the other line in your code the same way.

Your 2nd option worked perfectly! Thank you so much!!!