UBound Function

MSDN Home

MSDN
MSDN Library
Web Development
Scripting
Microsoft Windows Script Techn ...
VBScript
VBScript Language Reference
Functions (VBScript)

Functions (VBScript)

Abs Function
Array Function
Asc Function
Atn Function
CBool Function
CByte Function
CCur Function
CDate Function
CDbl Function
Chr Function
CInt Function
CLng Function
Conversion Functions
Cos Function
CreateObject Function
CSng Function
CStr Function
Date Function
DateAdd Function
DateDiff Function
DatePart Function
DateSerial Function
DateValue Function
Day Function
Escape Function
Eval Function
Exp Function
Filter Function
FormatCurrency Function
FormatDateTime Function
FormatNumber Function
FormatPercent Function
GetLocale Function
GetObject Function
GetRef Function
Hex Function
Hour Function
InputBox Function
InStr Function
InStrRev Function
Int, Fix Functions
IsArray Function
IsDate Function
IsEmpty Function
IsNull Function
IsNumeric Function
IsObject Function
Join Function
LBound Function
LCase Function
Left Function
Len Function
LoadPicture Function
Log Function
LTrim; RTrim; and Trim Functio ...
Math Functions
Mid Function
Minute Function (VBScript)
Month Function
MonthName Function
MsgBox Function
Now Function
Oct Function (VBScript)
Replace Function
RGB Function
Right Function
Rnd Function
Round Function
ScriptEngine Function
ScriptEngineBuildVersion Funct ...
ScriptEngineMajorVersion Funct ...
ScriptEngineMinorVersion Funct ...
Second Function
SetLocale Function
Sgn Function
Sin Function
Space Function
Split Function
Sqr Function
StrComp Function
String Function
StrReverse Function
Tan Function
Time Function
Timer Function
TimeSerial Function
TimeValue Function
TypeName Function
UBound Function
UCase Function
Unescape Function
VarType Function
Weekday Function
WeekdayName Function
Year Function

Switch View :

Classic

Lightweight Beta

ScriptFree

Feedback

Visual Basic Scripting Edition

UBound Function

Updated: September 2009

Returns the largest available subscript for the indicated dimension of an array.

UBound(arrayname[, dimension])

Arguments

arrayname: Required. Name of the array variable; follows standard variable naming conventions.
dimension: Optional. Whole number indicating which dimension's upper bound is returned. Use 1 for the first dimension, 2 for the second, and so on. If dimension is omitted, 1 is assumed.

Remarks

The UBound function is used with the LBound Function to determine the size of an array. LBound returns 0 because the lower bound for any dimension is always 0. Therefore, the length of a dimension is one greater than the output of the UBound function.

The following table shows the values returned by various UBound statements when they are applied to an array that has these dimensions: