98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Benefits of macros in a spreadsheet?
Benefits of macros in a spreadsheet?
Resolved · Low Priority · Version 2003
Bronwyn has attended:
Excel Advanced course
Benefits of macros in a spreadsheet?
How does macros benefit a spreadsheet
RE: Macros
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Finding cells that have data restrictionsClick anywhere on the worksheet. |