question about arrays

[Rick Charnes]

I've declared a one-dimensional, fixed-size array and assigned values to
SOME but not all of its elements. I know UBound() will return the upper
bound of the array. Is there a function that will return to me the
index number of the highest-numbered element **for which I've actually
assigned a value**? Thanks.

 

[Karl E. Peterson]

I've declared a one-dimensional, fixed-size array and assigned values to
SOME but not all of its elements. I know UBound() will return the upper
bound of the array. Is there a function that will return to me the
index number of the highest-numbered element **for which I've actually
assigned a value**? Thanks.

No. You'd have to roll yer own. Just loop backwards through the array, looking for
the first that isn't set to a default value, then bump by one.

 

[Jay Freedman]

No. You'd have to roll yer own. Just loop backwards through the array, looking for
the first that isn't set to a default value, then bump by one.

Or maintain a variable containing the last assigned value (or
equivalently, the next available value).

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[Karl E. Peterson]

Or maintain a variable containing the last assigned value (or
equivalently, the next available value).

Yeah, if this is a frequently needed value, that'd definitely be more efficient.