Login
Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

What Are Macros?

Itech Analytic Solutions
15/12/2017 0 0

i. Macros are little programs that run within Excel and help automate common repetitive tasks. Macros are one of Excel's most powerful, yet underutilized feature. Using macros, you can save hours and boost productivity manifold.

ii. Modules: Modules is the area where the code is written. This is a new Workbook, hence there aren't any Modules.

To insert a Module, navigate to Insert → Module. Once a module is inserted 'module1' is created.

Within the modules, we can write VBA code and the code is written within a Procedure. A Procedure/Sub Procedure is a series of VBA statements instructing what to do.

iii. Procedure: Procedures are a group of statements executed as a whole, which instructs Excel how to perform a specific task. The task performed can be a very simple or a very complicated task. However, it is a good practice to break down complicated procedures into smaller ones.

The two main types of Procedures are Sub and Function:

i. Function: A function is a group of reusable code, which can be called anywhere in your program. This eliminates the need of writing the same code over and over again. This helps the programmers to divide a big program into a number of small and manageable functions.

Apart from inbuilt Functions, VBA allows to write user-defined functions as well and statements are written between Function and End Function.

ii. Sub-Procedures: Sub-procedures work similar to functions. While sub procedures DO NOT Return a value, functions may or may not return a value. Sub procedures CAN be called without call keyword. Sub procedures are always enclosed within Sub and End Sub statements.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

Write A Query To Get Nth Highest Salary
WITH CTE AS ( SELECT EmpID, EmpName, EmpSalary, RN = ROW_NUMBER() OVER (ORDER BY EmpSalary DESC) FROM dbo.Salary ) SELECT EmpID, EmpName, EmpSalary FROM CTE WHERE RN = @NthRowUse of...
What Is Business Analysis?
BA is the practice of enabling change in an enterprise by defining needs and recommending solutions that value to the stakeholders.Business analysis enables an enterorise to articulate needs and the rationale...
Big Data and Its Impact On the Industry
Emerging Technologies such Big Data, Artifical Intelligence , Machine learning etc would play key role in all the enterprises Performances. For Example, by analyzing large amounts of information, both...

Pandu R. | 22/12/2017

0 0
0
What Is WorkTable In SQL Server?
What is WorkTable in SQL Server? USE AdventureWorks2014 GO SET STATISTICS IO ON GO SELECT * FROM Production.Product p CROSS JOIN Production.Product p1 GO If you run above query, there is good chance...

Amitava Majumder | 19/12/2017

0 0
0
Overview Of Database
A Database is a collection of related data organised in a way that data can be easily accessed, managed andupdated. Any piece of information can be a data, for example name of your school. Database is...

Sandeep Tiwari | 15/12/2017

0 0
0

Looking for BI Reporting Training?

Find best BI Reporting Training in your locality on UrbanPro.

Do you offer BI Reporting Training?

Create Free Profile »
Sponsored

Find Best BI Reporting Training?

Find Now »