sorry about my lack of VB knowledge, but can you send me the entire code?
Eg:
I need to copy whatever data is from column A to D on sheet 1
and then paste the entire data in sheet 2 as values only.