In this chapter we will discuss the use of Macros and Visual Basic for Application (VBA), that is, automating the execution of tasks requiring many repetitive steps.
Macros and VBA
Many times we have to perform repeated tasks and each time we have to go through clicking on various tabs and options to complete the task. Macros are basically a recording of mouse clicks, keystrokes, and mouse movement in the worksheet. Macros remember the steps we have to follow in completing a certain task. Lot of times we use Macros to solve problems requiring SOLVER or Goal Seek. Macros can also accommodate nested IF statements in a closed loop.
The Macros button is under the View tab on the Excel Ribbon or under the Developer ...