-- A macro is a small program designed to do a task.
Apr 11 2014 04:44 PM
-- Macro is basically used in Excel to automate a task that needs to be performed repeatedly.
-- A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. For example, if you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.
--When you record a macro, Excel stores information about each step you take as you perform a series of commands. If you start recording a macro, it will remember everything you do within a program. You then run the macro to repeat, or play back the commands. When the macro is played, it will repeat everything you did while you were recording the macro.
-- You can run a macro by choosing it from a list in the Macro dialog box. To make a macro run whenever you click a particular button or press a particular key combination, you can assign the macro to a toolbar button, a keyboard shortcut, or a graphic object on a worksheet.
MANAGING AND EDITING MACROS
-- After you record a macro, you can view the macro code with the Visual Basic Editor to correct errors or change what the macro does.