Userform button action - clear,copy paste and print crashes. Please help with code

Hi all,
can somebody have a look at the code please.
I will try to explain in easy way:
This code after i press "print sheet" button on the userform clears the content in the CheckSheet (Sheet2) worksheet, then it takes data from the userform copies it to the next row in the CheckSheet (Sheet2) worksheet, and then prints it out.
Everything works fine if i'm running userform when i'm on the CheckSheet worksheet. But if i'm trying to run this code (open the userform and click "print sheet" button) from any other worksheet for example "NEW" (Sheet3) it comes with the debug error and after i'm clicking back to the CheckSheet (Sheet2) worksheet, excel crashes.
I highlighted in red on witch line the code stops if i'm working when the worksheet "NEW" is active.
I'm trying to solve this for the last six hours, maybe somebody can help me please. Is there anything in the code what makes excel to crash?

Thanks

Please Login or Register  to view this content.

Hi, intex,

you should split up the activating of the sheet and after that (as it´s own command) select the range (I´d recommend not to Select nor Activate). Or you try

Please Login or Register  to view this content.

Ciao,
Holger

Hi, intex,

my bad, just copierd it over from your post. It should read

Please Login or Register  to view this content.

You´ve got the same error in your code on various other instances as well, you might consider to work with objects for the sheets where you would need to set a reference only at one point in code (that also means altering the code at one point only) or work with the codenames of the sheets.

Ciao,
Holger