About this lesson
A discussion of what variables are, and what they do for us when coding.
Download this lesson’s exercise file.What are variables?.xlsm
What are variables?
Introduction to variables.
When to use
When trying to understand what a variable is, and when to use one.
What They Are
- A variable is a piece of memory to temporarily hold objects or values.
- Variables can store items such as values or text strings
- Variables can store objects like workbooks, worksheets, or ranges.
What They Do
Variables allow us to:
- Target a specific value or object that we can then easily refer to later and use repeatedly.
- Write shorter code.
Hints & tips
You can change the properties of a variable at any time.
Lesson notes are only available for subscribers.