Macro Recorder

The below video will teach you how to use the macro recorder in Excel.

Uses of Macro Recorder:
1. The macro recorder will translate what you do manually in Excel to VBA code.
2. If there is something you are unsure of how to code, you can use the macro recorder to find out how to code it in VBA.

While using the macro recorder, you should keep in mind that if you simply copy and paste the code, then it may not work for every solution for data that is changing. You need to customize the code so that it works regardless of how the data changes in size or position. My other lessons will teach you how to program the basics in VBA so that your programs will work regardless of file size and content.