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.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Lear Excel, MrExcel podcast, episode number 1934 Record your macros into small steps and then record all of those macros in one.
Hey, welcome back to the MrExcel netcast.
I am Bill Jelen.
Another great tip from the Miami Power Excel seminar last weekend, 'Smerling' and who's already featured in Tuesday's podcast.
I suggested this.
We're talking about the macro recorder.
And Smerling said, "Yeah, hey, it's best recorder." Don't, don't try to make the whole report in one big macro.
Just do one step and then record another macro for next step and then record another macro for next step.
All right, which is, is great advice.
Because you know, for one, then at one step doesn't work, you just re-record that macro.
But, then Smerling had this great idea, she said, "Once you get all those little steps working, then you can record a macro," That does, all of these are macros, all right.
So, here I have a dataset.
I have two versions of the dataset and I've recorded three macros that does, did so formatting here.
And I am going to go "View Macros', 'Record Macro'.
And Record Macro called "Do All Steps".
Let's do, CTRL+SHIFT+S in there.
This macro runs all of the other macros.
Click OK.
It's another macro record is running, what I am going to do is ALT+F8 to get the list of the macros.
Here is my Macro01 for Add Stripes.
I run that.
Auto fill again.
Macro02AddTotals, Run that.
Auto fill again.
Macro03AddTitles Run that.
All right and then stop recording.
Now, you don't even have to go, look at the code but let's go, look at the code, see what it is.
So ALT+F11 Right. Now, here is the DoAllSteps Macro, which records the act of doing 'Application.Run', each of the other macros.
All right. Now, if you knew VBA, you could, there would be a faster way to do this, ofcouse.
But different people that just want to use macro recorder and never go into the VBA.
This is a great little trick and now always use CTRL+SHIFT+S to run that new macro that you just recorded, CTRL+SHIFT+S, goes through entire, so all of the other steps.
What a great, great tip for building macros, one build at a time.
You know, I'm working on a new book for next year called 'Macro Recorder Success' and this certainly would be a trick that will have to go in that book.
So, thanks to Smerling including that cool idea.
Thanks to you for stopping by.
I'll see you next time for another netcast of MrExcel.
Lear Excel, MrExcel podcast, episode number 1934 Record your macros into small steps and then record all of those macros in one.
Hey, welcome back to the MrExcel netcast.
I am Bill Jelen.
Another great tip from the Miami Power Excel seminar last weekend, 'Smerling' and who's already featured in Tuesday's podcast.
I suggested this.
We're talking about the macro recorder.
And Smerling said, "Yeah, hey, it's best recorder." Don't, don't try to make the whole report in one big macro.
Just do one step and then record another macro for next step and then record another macro for next step.
All right, which is, is great advice.
Because you know, for one, then at one step doesn't work, you just re-record that macro.
But, then Smerling had this great idea, she said, "Once you get all those little steps working, then you can record a macro," That does, all of these are macros, all right.
So, here I have a dataset.
I have two versions of the dataset and I've recorded three macros that does, did so formatting here.
And I am going to go "View Macros', 'Record Macro'.
And Record Macro called "Do All Steps".
Let's do, CTRL+SHIFT+S in there.
This macro runs all of the other macros.
Click OK.
It's another macro record is running, what I am going to do is ALT+F8 to get the list of the macros.
Here is my Macro01 for Add Stripes.
I run that.
Auto fill again.
Macro02AddTotals, Run that.
Auto fill again.
Macro03AddTitles Run that.
All right and then stop recording.
Now, you don't even have to go, look at the code but let's go, look at the code, see what it is.
So ALT+F11 Right. Now, here is the DoAllSteps Macro, which records the act of doing 'Application.Run', each of the other macros.
All right. Now, if you knew VBA, you could, there would be a faster way to do this, ofcouse.
But different people that just want to use macro recorder and never go into the VBA.
This is a great little trick and now always use CTRL+SHIFT+S to run that new macro that you just recorded, CTRL+SHIFT+S, goes through entire, so all of the other steps.
What a great, great tip for building macros, one build at a time.
You know, I'm working on a new book for next year called 'Macro Recorder Success' and this certainly would be a trick that will have to go in that book.
So, thanks to Smerling including that cool idea.
Thanks to you for stopping by.
I'll see you next time for another netcast of MrExcel.
