Thu 17 Jul 2008, 16:34Delegate Abigail said...
Abigail has attended:
Excel VBA Intro Intermediate course
Terminology
what is the difference between a variant and a variable?
Mon 21 Jul 2008, 16:14Trainer Roy said...
RE: Terminology
A variable is a named storage location in your code - typically within a Sub or Function.
For example, 'i' in: Dim i As Integer.
Variant is a 'don't-know-what-it-is' data type.
For example: Dim dunno As Variant.
You sometimes see Variant when arrays are being used.
/Roy
