I do not know how to assign this code to a commandbutton.

I was just googling this and nothing helps me out.

I right clicked the command button and selected view code where I had pasted this code. To assign the code I right clicked again and selected property and then closed the code and property. But after that when I click command button it only opens the code and nothing happens unfortunately.

This is really annoying. Why excel can't be simple and easy. I like using forms button it atleast says to assign macros. Excel has some features with some not others. Everytime you struggle for silly things.

Anyone can help resolving this issue please.