copy the data paste on the last row

[mawar5530]

Hi Friends,

Please help me to get solution for the error i face at attached code.

Much appreciate.

 

[Marc L]

Hi,​

​

try Offset rather than offect ‼​

 

[mawar5530]

Offset

Still error.

 

[Marc L]

​

But not the original error !​

​

As Activecell seems a non sense so at least well explain what is the purpose of this codeline …​

 

[mawar5530]

Receving_Update.xlsm

drive.google.com

please help to review my file, i just beginning in creating code.

 

[mawar5530]

Hi can anyone help me pls