Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

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()

 

You may also like...

2 Responses

  1. I need help, about array()

    I have three columns in a spreadsheet (example):

    what I need is to break to a new line each time it encounters the word “lot”, noting that there are products that do not have lots as in the delta example item.

    before
    ID Description observations
    123 product alpha (Lot: 3911924, Qty: 70, Dt Val: 30/10 / 2016Lote: 3901749, Qty: 20, Dt Val: 30/10 / 2016Lote: 4201107, Qty: 410, Val Deuteronomy: 30/07 / 2017Lote : 4249269, Qty: 4110, Dt Val: 30/08 / 2017Lote: 4258339, Qty: 390, Dt Val: 30/08/2017)

    after
    123 alpha product Lot: 3911924, Qty: 70, Dt Val: 10/30/2016
    123 alpha product Lot: 3901749, Qty: 20, Dt Val: 10/30/2016
    123 alpha product Lot: 4201107, Qty: 410, Dt Val: 07/30/2017
    123 alpha product Lot: 4249269, Qty: 4110, Dt Val: 30/08/2017
    123 alpha product Lot: 4258339, Qty: 390, Dt Val: 30/08/2017

    As I did not find solution and consider a good example, I appreciate the help

    • SJ says:

      You said you have 3 columns in spreadsheet, in your example can you tell me whats value those 3 columns contains, it looks to me a one single string,
      It can be done shouldnt take much time once i know what is there in 3 columns separately.

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: