VBA to copy only values and not formula [Closed]

-
I have this sentence in VBA that is working but it is copying the format as well . I really would appreciate. if you can tell me where to add Value so it will only copy the values.
Sheets("Sheet1").cells(i,1).copy Destination:=sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).offset(1)
See more