For something like this you may not even need copy/ paste
Sub MoveVal()
Range("A10").Value = Range("A1").Value
End Sub
Click here for a guide on how to add code tags
Click here for a guide on how to mark a thread as solved
Click herefor a guide on how to upload a file with your post