Maybe
Range("C7").Value = Sheets("Archive").Range("C7").Value