Counting How many Things in array!!

[Tequila_worm]

Originally posted by filburt1

Msgbox UBound(SomeArray) - LBound(SomeArray)

That wont work. Because my index starts at 2000 to 2010. and all the others are blanks. all i need is from 2000 to 2010.

And i cant use this eather

For i = MyArray(2000) to MyArray(2010)

Because sometimes the array wont be untill 2010. then it gives an error.


Thx for your help though.