Highest populated dimension of an array vba
- by Ommit
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.