Mega Code Archive
The LBound and UBound functions return whole numbers that indicate the lower bound and upper bound indices of an array
<![CDATA[
Sub FunCities2()
Dim cities(1 To 5) As String
cities(1) = "Las Vegas"
cities(2) = "Orlando"
cities(3) = "Atlantic City"
cities(4) = "New York"
cities(5) = "San Francisco"
MsgBox cities(1) & Chr(13) & cities(2) & Chr(13) _
& cities(3) & Chr(13) & cities(4) & Chr(13) _
& cities(5)
MsgBox "The lower bound: " & LBound(cities) & Chr(13) _
& "The upper bound: " & UBound(cities)
End Sub
]]>