You don't specify the workbook and worksheet you are copying from.

That will mean the code will copy from the active sheet, which might not be the correct one.