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).
Removing items. The VBA ArrayList object. The VBA ArrayList is also a very useful data structure if you want to work with dynamic arrays but donât want the hassle of having to constantly redefine (Redim) the size of the array. ArrayLists donât have a fixed size so you can keep adding items to it.