Hi there,
I have an issue with a copy code.
on attached file, please run the module6 (sub Test).
I don't understand why there's a debug error on
Code
Sheets("PORTO").Range(Cells(cel.Row, "A"), Cells(cel.Row, "C")).Copy Sheets("BATTAGLIA").Cells(lastrow + 1, 2)
reference on sheets and cells seems OK.
Thanks for any suggestion