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).
Excel VBA Tutorial Part 4 - VBA Function & Sub Procedures. Built-In VBA Functions. Before you consider creating your own VBA Functions, it is useful to know that there are a large number of built-in VBA functions that you can use in your code. For a list of the main built-in VBA functions, with examples, see the VBA Functions page.