Highest populated dimension of an array vba

Posted by Ommit on Stack Overflow See other posts from Stack Overflow or by Ommit
Published on 2010-05-06T13:45:01Z Indexed on 2010/05/06 18:08 UTC
Read the original article Hit count: 193

Filed under:
|
|
|

Say i have an single dimension array (to keep it simple). Is there a simple way to tell how many entries are populated, or the highest dimension of populated entries, other than to loop through and count them? I know Ubound finds the highest dimension of the array but that's not what I need. Is there something like Ubound but it only find populated entries, or the highest dimension populated?

Also, what if the array is multidimensional. I'm working in excel vba.

© Stack Overflow or respective owner

Related posts about arrays

Related posts about vba