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.

We can declare the variant data type as the usual data type, but while assigning the data type, we need to use the word “Variant.” Code: Sub Variant_Example1 () Dim MyNumber As Variant End Sub It makes the variable work any data now. We can assign any numbers, strings, dates, and many other things. Below is the demonstration of the same. Code:

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.