Syntax

LBound(ArrayVariable() [,dimension])

Description

Returns an Integer containing the lower bound of the specified dimension of the specified array variable.

Comments

The dimension parameter is an integer specifying the desired dimension. If this parameter is not specified, then the lower bound of the first dimension is returned.

The LBound function can be used to find the lower bound of a dimension of an array returned by an OLE automation method or property:

  LBound(object.property [,dimension])

  LBound(object.method [,dimension])

Examples

Sub Main()
  'This example dimensions two arrays and displays their lower bounds.

  Dim a(5 To 12)
  Dim b(2 To 100,9 To 20)

  lba = LBound(a)
  lbb = LBound(b,2)
  MsgBox "The lower bound of a is: " & lba & " The lower bound of b is: " & lbb

  'This example uses LBound and UBound to dimension a dynamic array to
  'hold a copy of an array redimmed by the FileList statement.

  Dim fl$()
  FileList fl$,"*.*"
  count = UBound(fl$)
  If ArrayDims(a) Then
    Redim nl$(LBound(fl$) To UBound(fl$))
    For x = 1 To count
      nl$(x) = fl$(x)
    Next x
    MsgBox "The last element of the new array is: " & nl$(count)
  End If
End Sub

See Also

UBound (function); ArrayDims (function); Arrays (topic).

L