What is a macro used for? – first, watch the next video which supplies an total instance of the right way to program a macro with the intention to change the formatting on a gross sales report.
After the video, we’ll stroll by means of a macro step-by-step and spotlight just a few of the generally used actions to be program right into a macro.
A macro has three principal methods to be recorded. Two are from the ribbon space and one isn’t. Experiment and discover your favourite approach to file it.
Macros are recorded in a program known as visible fundamental. To edit a macro, the developer tab wanted to entry the visible fundamental program.
We is not going to be diving into visible fundamental this time as a complete course all by itself. For now we’ll stick with the macro recording fundamentals.