Excel VBA Tutorial 02-Creating a Macro and Assigning recorded Code to Command Button

We can automate tasks in excel by recording macros or writing VBA Code. We can record a simple macro and execute it with simple command or we can assign VBA Code to a command button and execute it after clicking on the command button. Macro can save time in repetitive tasks in Excel

[vtpatil]

It is not working says method of range is wrong