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).
Create your own Functions in Excel VBA. Functions are closely related to the Subs you learned about in a previous section, and are set up in a similar way. The difference is that functions return a value (like the MsgBox function) whereas Subs don't return a value - they just get on and execute the code.