How to create Macros in Excel

 First, we will know what is macro?

So it's a program that automates repetitive tasks by recording and replaying a series of steps. 

Benefits of using macro

~Saves time

~ Easy to use

How to enable Marcos in excel..

Step 1 : Go to home

Step 2 : Customize the ribbon

Step 3 : Go to main tabs, Select developer.

How to record macro 

Step 1 : Go to developer ,then click on record macro

Step 2 : Type macro's name then select ok (there should not be spaces ).

Recording will start.. Stop the recording when the work is done..

When u click on visual and then go to module you will see the actual code which is running behind macro... 

You can edit that code as well. 

USE OF RELATIVE REFERENCE -

The macro will insert a row relative to the cell selected. 

Click the use relative reference button on the developer tab to toggle relative reference on and off.

For saving workbook containing macros, save it as 


EXCEL MACRO ENABLED WORKBOOK. 


💻



Comments

Post a Comment

Popular posts from this blog

PYTHON - OOP(OBJECT ORIENTED PROGRAMMING) - PART 1

Image
  OOP IN PYTHON --  To map with real world scenarios, we started using objects in code. This is called Object Oriented Programming. -- Utilizing functions reduces redundancy and enhances code reusability.  CLASS AND OBJECT IN PYTHON -- Class is a blueprint which tells us that what features should a class have. -- All the information which we have to store in particular object and writing in a class is what we call blueprint for creating an object # First we have to define class   * Creating class   class Student:                (Remember you always have to start class's name by capital letter)         name = "Anshula"     * After creating class, we need to create object Eg: s1 = Student () print(s1.name)     (object and instances of class is same) ** Suppose there is a factory and you are required to create a class. class Car:     color = "blue"     bran...
Read more

HOW TO USE SQL?

Image
WHY USE SQL (STRUCTURED QUERY LANGUAGE)? While Excel can only handle data containing up to one million row, businesses today generate data in the billions and trillions.To manage such vast amounts of data, databases and indespensable. NOW, HOW TO CREATE TABLES IN SQL? In SQL, we utilize the CREATE command to create tables.. SYNTAX :  CREATE TABLE   "TABLE NAME"( "COLUMN 1"   "data type for column 1" "COLUMN 2"  " data type for column 2" , "COLUMN N"   'data type for column n", [table constraint]); CONSTRAINTS: 1. NOT NULL : Column cannot have null values  2. DEFAULT : Provides a default value. 3. UNIQUE : All values in column are different. 4. CHECK : Makes sure that all values. 5. PRIMARY KEY : It is use to uniquely identify a row in the table. 6.FOREIGN KEY : It is use to ensure referential integreting of data. INSERT COMMAND The INSERT INTO statement is used to add new records into a database table. SYNTAX: --- Sin...
Read more