How to create, run and edit macros in excel?



0
I would like to know what are macros?
Why they are used? How to run , create and edit them?

1 Answer(s)


0

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

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password