Array Functions

VBA-Excel: Array Functions – Join() – Converts Array to String

by 
Description:

 Join () Function returns a String that consist of array elements separated by the delimiter provided.

Format:

Join(arrArrayName[,delimiter])

Arguments:
    • arrArrayName
      • Manda­tory
      • Type: Array
      • Array Name which needs to be converted into string.

    Read moreVBA-Excel: Array Functions – Join() – Converts Array to String

    VBA-Excel: Array Functions – LBound and UBound()

    by 
    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:

    VBA-Excel: Create Array using Array() Function

    by 
    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:

    • Elements
      • Manda­tory
      • Type: Any Data Type

    Read moreVBA-Excel: Create Array using Array() Function

    VBA-Excel: Array Functions – Split()

    by

    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: