Variant data type

Shown below is another VBA sub that performs the same operations as the last example. 

Ainv - Application.Run( Mat Pseudolnv , A) X - Application.MMult Ainv, b) bb = Application.MMult(A, a) 

an anonymous Dim statanent is used for aU variables (no data type is indicated). The structure and data type of these variables are established when they are assigned something. For example, in the case of the variable A, the assignment statement stores a 3 x 3 matrix of random integers. Although this example is more compact than the previous one, it is not as explicit. From an engineering perspective, since they both work the same, there is no reason to prefer one over the other. 

The following is an excerpt from The Power of Variants (http //www.tushar-mehta, com/publish train/book vba/08 variants.htm fml)  

However, there are many instances where a variant allows one to do things that otherwise would be impossible. The power of a variant comes from the fact that it is a simple data element and yet can contain any—and that means any—type of data. It can be a string or a Boolean or an integer or a real number. Hence, when the data type returned by a function can vary, one is obligated to use a variant for the returned value. 

---

The Variant data type is the default data type in VBA. Like Excel itself, the Variant data type handles and interconverts between many different kinds of data integer, floating point, string, etc. The Variant data type automatically chooses the most compact representation. But if your procedure deals with only one kind of data, it will be more efficient and usually faster to declare the variables as, for example. Integer. 

VBA uses the Variant data type as the default data type for variables and arguments. The Variant data type permits Excel to switch between floatingpoint, integer and string variables as required. 

You can also specify the data type of the return value. If none is specified, the Variant data type will be returned. In the example of the preceding section, MolWt returns a floating-point result. The Variant data type is satisfactory ... 

Finally, in the advanced section of the chapter, we will use the variant data type to create an array of arrays. This makes it possible to create, and work with, data structures that would otherwise be impossible. It also allows one to operate on an entire row of an array. 

With this background, it can be seen why the Variant data type was used in the prior example when it was desired to assign an entire array to a variable. 

The optional Lower To can be omitted. Type can be Integer, Single, Double, Variant, etc. See the complete list of data types in "VBA Data Types" in chapter 13.) A Variant array can hold values of different data types (e.g., 1.173 and "Billo, E. Joseph"). 

VHDL is a strongly typed language. This is in contrast to many C variants, in which operations on mismatched data types can be supported. In VHDL, t5Tping is strongly enforced where variables of different types need to be assigned, explicit casting needs to be performed. This is very much like the situation in a real electronic system, in which, for example, an non-tristate output pin should not be connected to a bus line. 

Since the sub involves matrices and vectors, the usual Opt ion Base 1 is used. Five variables are declared as dynamic arrays whose elements are of type Variant. This data type has been avoided in purely numerical computations but is necessary here to allow assignment to array variables. The statement... 

Fig. 14. Plot of the g values g,g ) and of the average g value g vs rhombicity (UJ of (a) wild type (open symbol) and variant forms (closed symbols) of the Rieske protein in yeast bci complex where the residues Ser 183 and Tyr 185 forming hydrogen bonds into the cluster have been replaced by site-directed mutagenesis [Denke et al. (35) Merbitz-Zahradnik, T. Link, T. A., manuscript in preparation] and of (b) the Rieske cluster in membranes of Rhodobacter capsulatus in different redox states of the quinone pool and with inhibitors added [data from Ding et al. (79)]. The solid lines represent linear fits to the data points the dashed lines reproduce the fits to the g values of all Rieske and Rieske-type proteins shown in Fig. 13.

Thus we calculated the value E based on equation (10) for several compounds and radicals during photosynthesis - tables 4 and 5. For radical - C =0 the calculations were made in two possible variants of activity of valence orbitals of carbon atoms. The compliance of calculated E values with reference data [12,13] was in the range of 5% for all bonds of covalence type without introducing the coefficient 0.83. 

---