@TutorialHorizon
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:
Description:
Join () Function returns a String that consist of array elements separated by the delimiter provided.
Format:
Join(arrArrayName[,delimiter])
Arguments:
Description:
IsArray() Function determines whether the specified variable is array or not and based upon that returns the Boolean value.
Format:
IsArray(varVariable)
Arguments:
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:
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 be converted into array.
Format:
Array(Element1, Element2, Element3…..ElementN)
Arguments:
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: