It is important to know that you when you record a macro, the Macro Recorder captures almost every move you make. Although VBA gives you the ability to automate processes within and between Office applications, it is not necessary to know VBA code or computer programming if the Macro Recorder does what you want.
Visual Basic Application (VBA) is a subset of the powerful Visual Basic programming language, and is included with most Office applications. These steps can include typing text or numbers, clicking cells or commands on the ribbon or on menus, formatting cells, rows, or columns, or even importing data from an external source, say, Microsoft Access. When you record a macro, the macro recorder records all the steps in Visual Basic for Applications (VBA) code.
