Hello,
I am trying to set a range that will go from cell A2 - the end of the data on the sheet.
Sheets("Approvals").Activate
Range("A2:Selection.End(xlDown").Copy
Can anybody let me know where i am going wrong please?
Thanks for your help.
Regards,
TD Rich.
I am trying to set a range that will go from cell A2 - the end of the data on the sheet.
Sheets("Approvals").Activate
Range("A2:Selection.End(xlDown").Copy
Can anybody let me know where i am going wrong please?
Thanks for your help.
Regards,
TD Rich.