Excel - How To Record Macros In Microsoft Excel - Record Macros in Small Steps - Episode 1934
1,947 views · Published 30 October 2014 · 2:40 · Indexed 6 November 2026
Channel: MrExcel.com · 2014 · Education
Microsoft Excel Tutorial: Record Excel Macros in Small Steps. Welcome to another episode of the MrExcel podcast. In this episode, we will be discussing a great tip from the Miami Power Excel seminar, where Smerling shared her advice on recording macros in small steps. Instead of trying to create one big macro for your entire report, Smerling suggests breaking it down into smaller steps and recording each step as a separate macro. This approach has many benefits, including the ability to easily re-record a single step if it doesn't work, and the ability to combine all the smaller macros into one macro that performs all the necessary steps. To demonstrate this, I have a dataset with two versions and have recorded three macros for formatting. Now, I will show you how to combine these macros into one using the macro recorder. First, go to "View Macros" and select "Record Macro". Name the macro "Do All Steps" and press CTRL+SHIFT+S. This macro will run all the other macros that we have previously recorded. Once you have finished recording, go to "View Macros" again and select "Run Macro". Choose the "Do All Steps" macro and press CTRL+SHIFT+S to run it. This will run all the other macros in sequence, saving you time and effort. If you are familiar with VBA, there may be a faster way to achieve this, but for those who prefer to use the macro recorder, this is a great trick to know. And don't worry, you don't even have to look at the code, but if you do, you will see that the "Do All Steps" macro uses the "Application.Run" function to run each of the other macros. This is a great tip for building macros one step at a time, and it will be featured in my upcoming book, "Macro Recorder Success". Thank you to Smerling for sharing this valuable advice and thank you for tuning in to another episode of the MrExcel podcast. Don't forget to use CTRL+SHIFT+S to run your newly recorded macro and save time on your tasks. See you next time for more Excel tips and tricks. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Recording Excel Macros in Small Steps (00:38) Benefits of Recording Macros in Small Steps (00:55) Example of Using Multiple Recorded Macros (01:38) Viewing the Code for the "Do All Steps" Macro (02:00) Using CTRL+SHIFT+S to Run Recorded Macros (02:19) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelvba #excelmacrorecorder This video answers these common search terms: how to record macros in excel how to record macros in microsoft excel how record macros in excel how to record a macro excel how to record a simple macro in excel how to use excel macro recorder to automate how may instructions can excel macro record how do i record a macro in excel? how do i record macros in excel where is record macro in excel how to use record macro in excel how to edit recorded macro in excel how to start recording excel macros where is the record a macro button in excel excel and how to record a macro how to use macro recorder in excel where are macro's recorded in excel where is the macro record button in excel how to get a macro to record in excel Another great tip from Smerling in Miami: When you have to automate a complex report, record several small macros instead of one big macro. Then, turn on the macro recorder while you run each small macro in order. The result is a DoAllSteps macro that run the other macros. Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153758/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920