Introduction to Macro


☞ A macro is an action or 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.

☞ It helps you to save time on repetitive tasks involved in data manipulation and data reports that are required to be done frequently.

☞ According to syllabus, we will learn the following topics related to macro.

1. using the macro recorder
2. write your own macro functions
3. passing arguments to a macro
4. agruments passed as values
5. macros to work like built-in functions
6. accessing cells directly
7. sorting the columns using macro