Micrsoft Excel has stopped working

Hi,
I am new and this is my first post.
I wrote a VBA code using excel 2010 and every time I run it, I get this error, "Microsoft Excel Has Stopped working". The thing is if I run it from the module, it works fine, but if I click on the button to which a macro is assigned the error popes up. The code is as follows.

Please Login or Register  to view this content.

Thanks in advance!

Hi Elikki,

Welcome to the Forum!

I have repaired my 2010 twice since I got it - have you tried repairing your Office 2010?

When we post code we put code tags around it - you need only to highlight your code and click on the #

Elikki, welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I have added them for you - this time