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).
Like variables, arrays in VBA are declared using Dim. Besides the array name, you also need to specify the number and type of values the array will store. * In VBA, as in most programming languages, count starts from 0. Hence, (6) actually means that there are 7 stored values (from 0 to 6).