When you start writing VBA macros one of the most useful functions you will use is the VBA macro recorded.
Many users over the years have taught themselves how to code VBA using just this feature (there are even a few of them here at ImproveYourExcel).
This video shows you how to use the developer Toolbar to record your own VBA macros and describes the difference between the incremental and absolute referencing that the macro recorder will use. It is vital that you understand this before you do too much with this magic button.
The one thing this video is missing is to show you the code the record macro button produces. To do this select Alt F11 after you have recorded your macro.
If you have enjoyed this video then please share it or like it by using the buttons above. Or why not leave us a comment below