Variant Declaration

As is the case with Visual Basic, when a variable is introduced in VBA, it is not necessary to declare it first (see for an exception to this rule). When a variable is used but not declared, it is implicitly created as a variant data type. Variants can also be declared explicitly using As Variant. Both of the following example declarations as treated identically in VBA:

Dim vntVar ' implicit variant declaration
Dim vntVar As Variant ' explicit variant declaration

The IsEmpty( ) function can be used to find out if a variant variable has been previously assigned a value.