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:

  1. From the Excel menu select Tools=>Macro=>Record New Macro
  2. Name your macro and select ok
  3. Perform some task such as put the word apple in cell a1 and banana in b1.
  4. From the Excel menu select Tools=>Macro=>Stop Recording
  5. Delete the apple and banana example words
  6. Press alt+f8 to open macro window
  7. 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:

  1. Removing Macros from a Workbook Q: How do I remove all the macros from my...
  2. Playing with VBA in Excel, Without Knowing VBA! Introduction to user defined functions and VBA in Excel....
  3. Data Validation List on Seperate Sheet How to create list for data validation on different sheets...
  4. Paste Special – Transpose Excel Transpose...
  5. Duplicates – Finding and Removing in Excel There are many occasions when you may need to remove...

This entry was posted on Thursday, October 23rd, 2008 at 11:59 am and is filed under Excel Quick Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Use Excel Macro Recorder to Handle Repetitive Steps”

  1. Excel Tips and Tricks » Blog Archive » Playing with VBA in Excel, Without Knowing VBA! on October 27th, 2008 at 1:27 pm

    [...] then looking at the code the macro recorder places in the VB Editor. Check out a past post on the macro recorder to learn [...]

Leave a Reply

You must be logged in to post a comment.