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).
Category: VBA Functions | [Item URL]. VBA does not include a method to retrieve a value from a closed file. You can, however, take advantage of Excel's ability to work with linked files. This tip contains a VBA function that retrieves a value from a closed workbook.It does by calling an XLM macro.ategory: VBA Functions | [Item URL]. VBA does not include a method to retrieve a value from a closed file. You can, however, take advantage of Excel's ability to work with linked files. This tip contains a VBA function that retrieves a value from a closed workbook. It does by calling an XLM macro.