Overview:

In this course, participants will learn how to:

• Create user-defined functions in macros
• Automate SUM functions with a macro

Course Outline

TOPIC A: Create User-Defined Functions

• User-Defined Functions
• Types of Functions
• Arguments
• How to Create User-Defined Functions
• Activity: Creating and Applying a User-Defined Function

TOPIC B: Automate SUM Functions

• Declared Range Objects
• The Set Statement
• Range Object Cell Addressing
• The Rows Property
• The Formula Property
• The Columns Property
• Address Property Cell Reference Settings
• How to Automate SUM Functions
• Activity: Summing Data Ranges of Unknown Length

Summary

Review Questions

Review Questions - Answers

Lesson Lab 5-1

Course Completion