The LBound and UBound functions return whole numbers that indicate the lower bound and upper bound indices of an array. : Array Function « Data Type « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Data Type » Array Function 
The LBound and UBound functions return whole numbers that indicate the lower bound and upper bound indices of an array.
 
Sub FunCities2()
    Dim cities(To 5As 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

 
Related examples in the same category
1.Using the Array Function
2.avoids the error "Subscript out of range"
3.Use IsArray function to check if a variable is an array
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.