How to create, run and edit macros in excel?


1 Answer(s)


-- A macro is a small program designed to do a task.

-- 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.


RECORDING MACROS

--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.


RUNNING MACROS

-- 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.