Paste as Values

[booton]

Hello everyone.

i have this code that is pasting one cell into another sheet at the end but it is keeping the format. i want to paste as value that cell. can someone please help me? Thanks!!!!

Sub Copy_Timestamp()

    Sheets("Historical_Excel").Range("G2").Copy Worksheets("Time_Stamp").Range("A" & Rows.Count).End(xlUp).Offset (1)
        
End Sub

 

[Shiseiji]