0
Macro is feature in MS Excel software which records all the steps and all the steps can be repeated whenever a same task is required to be performed. It helps in reduction of time in performing monotonous task. Macro is available in Tools menu.
Wiki User
∙ 14y ago
Wiki User
∙ 11y agoA macro is a small program designed to do a task. It is useful for doing repetitive tasks. If you start recording a macro, it will remember everything you do within a program. Once you stop recording. it stops remembering, but still stores this previous info. When the macro is played, it will repeat everything you did while you were recording the macro. So a macro is basically a repeater. You can save the marcro and use it again regularly. It may be for some task that you do quite often, that is always done the same way and has a lot of steps. Instead of doing them one by one every time you need to do the task, the steps can be saved in a macro.
Macros can be written directly with programming code, using the language called Visual BASIC for Applications, which is referred to as VBA. It is similar to but not the exact same as Visual BASIC. By using VBA you can do more sophisticated and powerful macros.
Wiki User
∙ 13y agoA Macro is a small program which is typed into a Macro File. In Excel click Help on the toolbar then type "Macro". This will tell you what they are, what they do and how to create them. They are very useful. You can also on the toolbar click on "Tools" then "Macros" to see what is there.
Wiki User
∙ 15y agoMacros are things that save time, ie instead of typing something more than once, you can use a macro, they do other things too but I am not into programming language, Visual Basic.
Wiki User
∙ 10y agoMacros in Excel are used for tasks with high repetition. They are basically a way to automate certain functions and commands to greatly speed up the processing of large volumes of data.
Wiki User
∙ 10y agoThe use of Macros in Excel is that Macros is a set of instructions that are stored in the Excel program software. These instructions tell the program how to work properly.
Wiki User
∙ 10y agoTo record.
Add your answer:
Earn +20 pts
How do you get merged cells to auto height with out a macro in Excel?
I don't know about Excel 2007 but in 2003 you cannot do it with a macro. An inherent feature constratint of Excel 2003.
What virus attaches to documents such as word or excel files?
Macro viruses use Microsoft Word and Excel's capabilities to embed code and programs into the document. When the document is opened, the macro virus is executed and infects your computer.
What are two words an Excel macro ends with?
End Sub.
How many lines of macro code an excel sheet accept?
3
Can run access or excel macro codes on pdf files?
Yes! you can!
WHAT a virus that is attached to documents such as Word or Excel files?
macro virus
What is the name of the custom toolbar where where you can attach your own macro?
In Excel 2013 what is the name of the custom toolbar where you can attach your own macro buttons
You have recorded a macro. By mistake you recorded an action in it which you do not want. How will you remove the unwanted action without having to record the whole macro again?
All you need to do is edit the macro and remove the section you do not want in the macro. Excel 2007: From the Developer tab on the Menu ribbon, click on the Visual Basic icon in the Code section. See related links for a detailed tutor on how to edit an Excel macro.
What is the name of the custom toolbar where you can attach your own macro buttons?
In Excel 2013 what is the name of the custom toolbar where you can attach your own macro buttons
How do you edit a macro stored in your personal macro workbook in excel?
You can open the Macro dialog box by pressin Alt - F8. Then choose the macro you want and click Edit and it will bring you into the code of the macro. You do need to be careful and to be sure you know what you are doing before changing anything.
How do you identify the type or name of a virus which auto-inserts running text into Word Excel and Google?
You mean a macro virus? Macro viruses infect Microsoft Excel and Word documents. When the infected document is viewed, the virus is executed.
Create Auto save macro in Excel?
In XLS 2003 you can simply turn the "Save AutoRecovery info" in EXCEL (Tools/Options/Save)
