Explain Macro in MS-Excel.

Macros are used for iterating over a group of tasks. Users can create macros for their customized repetitive functions and instructions. Macros can be either written or recorded depending on the user.

Asked on February 23, 2019 in Excel.
Add Comment


  • 4 Answer(s)

    If you have tasks in Microsoft Excel that you do repeatedly, you can record a macroto automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes.

    Answered on February 23, 2019.
    Add Comment

    macro is an automated input sequence that imitates keystrokes or mouse actions. A macro is typically used to replace a repetitive series of keyboard and mouse actions and are common in spreadsheet and word processing applications likeMS Excel and MS Word. The file extension of amacro is commonly .MAC.

    Answered on March 8, 2019.
    Add Comment

    Excel macros save you time and headaches by automating common, repetitive tasks. And you don’t have to be a programmer or know Visual Basic Applications (VBA) to write one. With Excel 2013, it’s as simple as recording your keystrokes. Use these tips to make macro recording a cinch.

    Answered on March 8, 2019.
    Add Comment
    VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs.
    • 1 Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros. …
    • 2 MsgBox: The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program.
    Answered on March 8, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.