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).
More information: This function is very handy for checking whether a value exists in an Array. Ordinarily most programmers will use the LBound / UBound values of an array to loop through the array. Well here is a fast way of checking the Array. Notes: 1) The array must be declared as a string array or an array of variants. 2) This only works in VB6 because of the use of the Join function.