VBA Set Worksheet not working.

[Wskip49]

Trying to move Data from Invoice sheet to Register Sheet. I’ve tried to write a macro to do that but the “Set WS1 = Worksheets("Invoice")” seems to be a bug but I don’t know why.

[LeoTaxi]

Please Login or Register  to view this content.

Red part give the error, change to E28 and it works

Please Login or Register  to view this content.

Kind regards
Leo

[Wskip49]

Thanks so much.