Description: LBound and UBound() Functions returns the starting index ( Lower Bound) and Ending index (Upper Bound) of an array. Format: LBound(arrArrayName [, dimension]) UBound(arrArrayName [, dimension]) Arguments: arrArrayName Mandatory Type: Array Array...
Description: Split() Function returns one dimensional array containing the substrings, after splitting the main string based upon the delimiter provided. Format: Split(strMainString [, delimiter[,intlimit[, vbCompare]]]) Arguments: strMainString Mandatory Type: String String which will be...
For creating two dimensional dynamic array in excel, follow the steps below: Declare the two dimensional Array Resize the array Store values in array Retrieve values from array