Description: Filter() Function returns one dimensional array containing the filtered array elements based upon the filter options provided Format: Filter(arrArrayName,FilterValue [, Include[, vbCompare]]) Arguments: arrArrayName Mandatory Type: Array Array which needs to be filtered
Description: Join () Function returns a String that consist of array elements separated by the delimiter provided. Format: Join(arrArrayName[,delimiter]) Arguments: arrArrayName Mandatory Type: Array Array Name which needs to be converted into string.
Description: IsArray() Function determines whether the specified variable is array or not and based upon that returns the Boolean value. Format: IsArray(varVariable) Arguments: varVariable Mandatory IsArray() function evaluates this string.
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: You can create an array using Array() function. You need to provide all the elements which you want in an array inside Array() and store it in a variable and that variable will...
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...