Learn Excel - Record Macros in Small Steps - Podcast 1934

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Oct 30, 2014.
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.
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,510
Messages
6,114,044
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top