PDA

View Full Version : Solved: length of array



ProteanBeing
01-30-2008, 10:56 AM
I have defined an unspecified array

dim MyArray() as variant

is there a keyword or function that can tell me how many items are in the array?

Bob Phillips
01-30-2008, 11:01 AM
UBound(MyArray) - LBound(MyArray) + 1

ProteanBeing
01-30-2008, 12:06 PM
Thanks.