VBA UBound & LBound Functions
In this Article
UBound Description
Returns the highest subscript for a dimension of an array.
Simple UBound Examples
|
1 2 3 4 |
Sub UBound_Example() Dim a(3 To 10) As Integer MsgBox UBound(a) End Sub |
Result: 10
UBound Syntax
|
1 |
UBound(ArrayName, [ Dimension ]) |
The UBound function contains 2 arguments:
ArrayName: Name of Array variable.
Dimension: [Optional] Integer indicating which dimension’s lower bound is returned. Use 1 for the first dimension, 2 for the second, etc. 1 if ommitted.
Examples of Excel VBA UBound Function
|
1 2 3 4 5 6 7 |
Sub UBound_Example1() Dim arrValue(1 To 5, 4 To 8, 12 To 25) MsgBox UBound(arrValue) MsgBox UBound(arrValue, 1) MsgBox UBound(arrValue, 2) MsgBox UBound(arrValue, 3) End Sub |
Result: 5, 5, 8, 25
LBound Description
Returns the lowest subscript for a dimension of an array.
Simple LBound Examples
|
1 2 3 4 |
Sub LBound_Example() Dim a(3 To 10) As Integer MsgBox LBound(a) End Sub |
Result: 3
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!
Learn More!!
LBound Syntax
|
1 |
<strong>LBound</strong>(ArrayName, [ Dimension ]) |
The LBound function contains 2 arguments:
ArrayName: Name of Array variable.
Dimension: [Optional] Integer indicating which dimension’s lower bound is returned. Use 1 for the first dimension, 2 for the second, etc. 1 if ommitted.
Examples of Excel VBA LBound Function
|
1 2 3 4 5 6 7 |
Sub LBound_Example1() Dim arrValue(1 To 5, 4 To 8, 12 To 25) MsgBox LBound(arrValue) MsgBox LBound(arrValue, 1) MsgBox LBound(arrValue, 2) MsgBox LBound(arrValue, 3) End Sub |
Result: 1, 1, 4, 12
