What is Macro in Microsoft Excel?

We have a task in Microsoft Excel which we do repeatedly and it is the time taking task so we can a record a Macro to automate that task to take less time. A Macro is an action or set of actions that we run as per our tasks in Microsoft Excel. When we create a Macro then we are recording our steps followed by mouse clicking and keystrokes. After creating Macro, we can change the syntax of Macro as per our need.

Types of Record Macro

There are two types of Record Macro

(A). Absolute Macro – When we record Macro it is by default Absolute Macro. This is Fixed Macro means, when we run this Macro the Macro will always run with the same Range in Excel.

How to Record Absolute Macro

First of all, we have to enable Developer Tab in Excel Ribbon. Click here. We need to follow some Steps.

(1). Go To Developer Tab

what is macro

(2). Click Record Macro

what is macro in excel

(3). Dialog Box of Record Macro must active.

We have to mention some information about Macro.

(i). Macro Name – Each Macro’s name must unique, Alphanumeric/Alpha. We cannot use any special character except Under Score (_) and we cannot use Space also.

(ii). Shortcut keys – We should not assign reserved shortcut keys.

(iii). Store Macro in – There is three available storage for store Macro –

        (a). This Workbook

        (b). New Workbook

        (c). Personal Macro Workbook

        (d). You can describe a Macro in the description box.

(4). Click OK

 

How to Stop Absolute Macro?

what is macro in excel 2007

(1). Click Stop Recording

(B). Relative Macro – When we want to record Macro as Relative Macro so we need to use [Use Relative References] option for Relative Macro. This Macro will run with dynamic Range in Excel. We have to give attention about active cell while record this Macro because an Active cell is most useful for Relative Macro.

How to Record Relative Macro

We need to follow some Steps.

(1). Go To Developer Tab

macro in excel 2007

(2). Click [Use Relative References] option

what is macro programming

(3). Click Record Macro

macro programming in excel

(2). Dialog Box of Record Macro must active

We have to mention some information about Macro.

(i). Macro Name – Each Macro’s name must unique, Alphanumeric/Alpha. We cannot use any special character except Under Score (_) and we cannot use Space also.

(ii). Shortcut keys – We should not assign reserved shortcut keys.

(iii). Store Macro in – There is three available storage for store Macro –

        (a). This Workbook

        (b). New Workbook

        (c). Personal Macro Workbook

        (d). You can describe a Macro in the description box.

(4). Then Click OK

How to Stop Relative Macro?

what is absolute macro

(1) Click Stop Recording

What is Macro in Microsoft Excel?

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *