Lessons
A basic overview of Excel macros and how to set up the environment in order to use them....
Introduction
What is a macro?
Why use macros?
The manual approach
The Created Code
Conclusion
Lesson 2: The Basics of VBA
This lesson will introduce you to the elements of the VBA language and how it is used in Excel macros....
Introduction
Variables
Dimensions of your Worksheet
Testing and Debugging code
Conclusion
Lesson 3: Project 1
This lesson will focus on a real project and we will see how to use macros to solve the problem....
Introduction
Conclusion
Lesson 4: Project 2
This lesson will tackle a more involved example involving multiple worksheets....
Introduction
The Code
Conclusion
