Benefits of macros in a spreadsheet?

Bronwyn

Thank you for your question

Introduction

In Excel, we can automate tasks by using macros. A macro is a set of instructions that tells Excel what to do. These commands are written in a computer programming language called Visual Basic for Applications (VBA).
We can create macros using the Macro Recorder provided by Excel. Just as a tape recorder can be used to record sounds which can be played back later, so the Macro Recorder can record your actions into a macro. In this way we can create macros without learning about Visual Basic. These macros can be run whenever you wish, automatically repeating your recorded actions and so saving you time and effort.

We run a 2 day Visual Basic Excel Course where we actually write macros from scratch by entering instructions into a module. Solutions to these exercises are given in by your trainer also on this course. Macros are also referred to a s procedures