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).
by Hollie Miller Excel, Excel tips 1 Comment. VBA, Visual Basic for Applications, is the programming language that Excel understands and although Excel provides an easy to follow macro wizard, using VBA enables you ultimate control in ensuring the macro performs exactly as you want it to.