Loops

• The concept of looping
• Different types of loop
• For – Next Loop
• Do – Loop
• For Each Loop

Collections and Object Hierarchy

• A closer look at how objects are organised

Exploring the Range Object

• Referring to a Range
• Collections and Items
• The CurrentRegion Property
• The Offset & Resize Properties

Calling Sub Procedures

• Defining arguments in called procedures

User Defined Functions

• Using Excel Worksheet Functions in VBA
• VBA Functions
• User-Defined Functions
• Declaring Variables in User Defined Functions
• Using Ranges in User Defined Functions

Writing Macros

VBA Terminology

• Procedures, Subroutines, Macros, Functions
• Objects, Methods, Properties

Further Testing and Debugging Techniques

• Types of Error and Debugging
• Stepping Through a Procedure
• Monitoring Variable Values
• Break Mode
• Testing and Debugging Code
• Watch & Immediate Window