I have defined an unspecified array
[VBA]dim MyArray() as variant[/VBA]
is there a keyword or function that can tell me how many items are in the array?
I have defined an unspecified array
[VBA]dim MyArray() as variant[/VBA]
is there a keyword or function that can tell me how many items are in the array?
"The amount of stupid people in the world is God's way of punishing the smart people" - protean_being
[vba]
UBound(MyArray) - LBound(MyArray) + 1
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks.
"The amount of stupid people in the world is God's way of punishing the smart people" - protean_being