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

Example:

Function FnLowerUpperBound()

    Dim arrOneDArray(1 To 5)

    Dim arrTwoDArray(1 To 5, -2 To 10)

    Dim arrMultiDArray(0 To 4, -2 To 4, 2 To 7)

  Dim strString

  strString = "LBound of arrOneDArray is: " & LBound(arrOneDArray) & vbCrLf

  strString = strString & "LBound of 2nd dimension of arrTwoDArray is: " & LBound(arrTwoDArray, 2) & vbCrLf

  strString = strString & "LBound of 3rd dimension of arrMultiDArray is: " & LBound(arrMultiDArray, 3) & vbCrLf

  MsgBox strString

  strString = "UBound of arrOneDArray is: " & UBound(arrOneDArray) & vbCrLf

  strString = strString & "UBound of 2nd dimension of arrTwoDArray is: " & UBound(arrTwoDArray, 2) & vbCrLf

  strString = strString & "UBound of 3rd dimension of arrMultiDArray is: " & UBound(arrMultiDArray, 3) & vbCrLf

  MsgBox strString

End Function
Array functions-LBound
Array functions-LBound

 

Array functions-UBound()
Array functions-UBound()