The correspondence of a pronoun with its antecedent in number (singular, plural), person (first, second, third), and gender (masculine, feminine, neuter).
Basic functions. 1  LBound(Array, Rank) â return the lowest subscript (index range) of the VBA Array within a certain dimension (Rank). 2  UBound(Array, Rank) â return the highest subscript (index range) of the VBA Array within a certain dimension (Rank). 3  ReDim â reallocate storage space for the array (set new array size).
By definition, an array is a group of variables with the same data type and name. We differentiate each item in the array by using subscript, the index value of each item, for example name (1), name (2), name (3) .......etc. 21.2 Declaring Arrays in Excel VBA. We use Dim statement to declare an array just as the way we declare a single variable.In VBA, we can have a one dimensional array, two dimensional array or even a multidimensional array (up to 60) 21.2(a) One Dimensional Array. The general statements to declare a one dimensional array in Excel VBA is as follows: