If you have ever had to change the same thing on 50 workbooks, then you probably have already discovered the Excel macro recorder. The macro recorder will record your every click which you can then play back to repeat the task you just performed. It is an easy way of automating task.
To use the macro recorder:
- From the Excel menu select Tools=>Macro=>Record New Macro
- Name your macro and select ok
- Perform some task such as put the word apple in cell a1 and banana in b1.
- From the Excel menu select Tools=>Macro=>Stop Recording
- Delete the apple and banana example words
- Press alt+f8 to open macro window
- Select your macro from the list and choose run
If you did everything correctly, your example words should have been written out again in the same cells.
That is the macro recorder in a nutshell!
Related posts:
- Removing Macros from a Workbook Q: How do I remove all the macros from my...
- Playing with VBA in Excel, Without Knowing VBA! Introduction to user defined functions and VBA in Excel....
- Data Validation List on Seperate Sheet How to create list for data validation on different sheets...
- Paste Special - Transpose Excel Transpose...
- Duplicates - Finding and Removing in Excel There are many occasions when you may need to remove...
[...] then looking at the code the macro recorder places in the VB Editor. Check out a past post on the macro recorder to learn [...]