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).
One-dimensional Array | Two-dimensional Array. An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the index number. To create a one-dimensional array, execute the following steps. Place a command button on your worksheet and add the following code lines: