What do Microsoft Excel macros do?
Getting the most out of Microsoft Excel means getting it to do the work for you. One way to do this is by use of macros, which are short, repeatable sequences that can be triggered by pressing a single button.Designing A MacroThink about something you do in Excel that’s repetitive or tedious. Anything that requires copying information from one cell to another is a good candidate. If it’s something that has a lot of little steps that must be done in exactly the right order, it’s a prime candidate for a macro.Creating A MacroMacro creation starts by turning on the macro recorder; this can be found in the View menu. You turn on the recorder, perform a sequence of operations and then press “stop”.Running A MacroTo run a macro, load the macro with the Macros tool (in the View pane) and press the Run button. This will run the sequence of events you recorded earlier.Editing A MacroYou can also click “Edit” on the Macro window, which brings up the Microsoft VBA editing window. This will show y
