Go to: Articles List
Part 1 | Part 2 | Part 3 | Part 4
There are three main functions related to Arrays that you should be aware of:
LBound(), UBound(), and Split(). I will define each and explain when to use
each of them.
LBound(ArrayName[, ArrayDimension])
- Returns the lowest element available in an array, usually 0.
- ArrayName is any valid array
- ArrayDimension is an option parameter, it specifies which dimension of the
array you want to find the lower bound of.
- ArrayDimension defaults to 1, so if you are checking a 1 dimensional array
or you want to check the first dimension you can leave this out.
UBound(ArrayName[, ArrayDimension])
- Returns the highest element available in an array.
- ArrayName is any valid array
- ArrayDimension is an option parameter, it specifies which dimension of the
array you want to find the upper bound of.
- ArrayDimension defaults to 1, so if you are checking a 1 dimensional array
or you want to check the first dimension you can leave this out.
- If your array has 10 elements (remember zero base) then the upper bound
would be 9.
Split(StringToSplit[, DelimiterToUse, HowMany])
- Returns a one dimensional array
- StringToSplit is any valid string
- DelimiterToUse is the character that you want the string to be split by.
- HowMany is the number of elements you want to limit the array to.
- DelimiterToUse and HowMany are optional parameters.
- If you leave out the DelimterToUse, the function uses a space to split the string.
Example:
Dim MyString, MyArray
MyString = "apples,oranges,grapes"
MyArray = Split(MyString, ",")
Result:
A one dimensional array called MyArray with 3 elements.
|
|
|
|