using the Visual Basic Editor. Although many macro users rarely venture past the Macro Recorder, this book shows you how to harness the power of Visual Basic for Applications, or VBA, to create more complex macros. No matter how simple or complex a macro, you write them all using VBA.
Macros are a term common to the spreadsheet world. All spreadsheet packages on the market provide the ability to create macros to automate tasks, and Excel is no exception. Although all Microsoft Office products provide the ability to create macros, they are best suited for Microsoft Excel.
As an Excel user, you may have a series of tasks that you perform frequently. By creating a macro to perform complex or repetitive tasks, you can save time by pressing a simple keystroke each time you want to perform the tasks.
Was this article helpful?