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

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
    • Manda­tory
    • Type: Array
    • Array whose lower or upper bound needs to found

    Read more

VBA-Excel: Array Functions – Split()

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:

  • str­Main­String
    • Manda­tory
    • Type: String
    • String which will be split

    Read more