Counting elements in an array

[AndySuk]

Hi

Is it possible to count the number of elements I have in an array programatically?

The array is within a vba module but and the count is used in several places. The count is assigned to a variable but I'd like the count to be dynamic in case someone adds an element but doesn't change the counter.

Thanks

[jasoncw]

You can use UBound to determine the upper bound number of elements. Keep in mind that it starts with 0, so if you want actual number of elements (assuming you are not using Option Base 1), you wound need to use:

Please Login or Register  to view this content.

HTH

Jason

[Andy Pope]

If you use both LBound and UBound you do not have to worry about what values were used.

Please Login or Register  to view this content.

[AndySuk]

wicked!

Thanks guys.