If you don’t declare a variable type, your variable will be considered variant. To declare an Variant variable, you use the Dim Statement (short for Dimension): Dim varName as Variant Dim rng as Variant Then, to assign a value to a variable, simply use the equal sign: varName = "John" rng = Sheets(1).Range("A1")

The following statements create Variant variables: VB Dim myVar Dim yourVar As Variant theVar = "This is some text." The last statement does not explicitly declare the variable, but rather declares the variable implicitly, or automatically. Variables that are declared implicitly are specified as the Variant data type.

To declare a variant array, you can write this simple statement Dim varNames() This is considered a dynamic variant array. Notice that you don’t need to specify the data type (it is assumed to be variant) or the array size.