Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the fastest way to create Macro in excel?

user-image
Question added by khaled saud , Production Planning Engineer , Atlantic ECET
Date Posted: 2017/06/20

you can press macro record and then record the steps in order.

PRABHAKAR PANDEY
by PRABHAKAR PANDEY , IT Enabled Sr. Process Representative , NTT Data

Press Alt (L+R) as a shortcut to start recording your Macro

Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

you can do that on the fly by start macro record.

think of this also, you can start your code by recording, then after the finish, you can edit it to make it faster.

 

Afraz Ali Lashari
by Afraz Ali Lashari , Office Work Computer/Typist andMisc Work District & Sessions Court , Government

With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro which will be executed after clicking on a command button. First, turn on the Developer tab.

Developer Tab

To turn on the Developter tab, execute the following steps.

1. Right click anywhere on the ribbon, and then click Customize the Ribbon.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.