Hi…
can anybody tell me that what is macro and how to use it in excel?
thanks in advance
Answered By
anmmool
0 points
N/A
#123651
How to use Macros in Excel
Macro allows you to automate some repetitive tasks by recoding mouse clicks and keyboard strokes which can be played later when doing the same tasks. It enables you to record the commands when performing a certain task, when the macro is run later, it will replay the same exact commands in the order in which they were recorded and this will appear in excel as if you have keyed in the commands.
They are pretty much easy to create and you need not have any background in programming or Visual Basic for Application (VBA). All you need to do is start the macro, normally perform the sequence of actions as usual and stop the macro once you are done. Excel will record these actions behind the scenes in a language it best understands known as VBA.
How to use Macros in Excel
This tutorial will take you through how to use the Microsoft excel macro recorder, it is a built-in feature of Excel and is very simple to use. Macros are a very useful feature of Excel, especially if you find yourself constantly repeating the same tasks on different cells, or worksheets. Â They enable you to record the repetitive actions and then repeat the actions at the click of a button.
The simplest way to create a macro in Excel is to use the macro recorder. Â The first step is to open up the workbook (file) that you wish to use the macro in. Then click on Tools, hover over Macros and then select Record new macro from the menu.
Everything you do now in the workbook will be recorded, so manually go through the process that you want your macro to recreate, for instance adding up a column. When you have finished click on the small blue square within the macro recording box to stop recording.
Watch this video for a tutorial on how you can download and install JitBit Macro Recorder:
