Hi,

May I request for your help as I encounter a run time error that says "Select method of Range class failed". As I clicked the debug button, it highlights my below code. The copy and paste function works however, a run time error encountered.

Sheets("Sheet1").Select
Sheets("Sheet1").Range("K7").Select
Selection.End(xlDown).Select
Selection.Copy
Sheets("Sheet2").Range("A2").PasteSpecial Paste:=xlPasteValues

I hope you can help me on this.

Thank you.

Regards,
Madz