Empty Array

Is it possible to set an array back to an empty state? By this I mean the
state it 's in when created like this:

Dim Ranges() As Variant

Thanks,

Dale

 

Got it. "Erase".

 

would ReDim Ranges(0) do that?
or ReDim Ranges() ?
don't know if it would or why you'd need to do that but it's an interesting
question.

 

would ReDim Ranges(0) do that?

Nope. That would be an array with one element.

Nope. Thats improper syntax.

Erase Ranges works fine. The reason I need it empty is because I check
inside a loop whether the array has been instantiated or not. Another good
reason to start using collections I suppose.

Best regards,

Dale

 

sorry didn't see your repost before i posted those dumb thoughts!

Glad you got it.

amen to that!

unless i'm handed an array and have to deal with it, GetAttributes, Split
etc - well you just gotta deal with the array, but otherwise ....i never
create one anymore since learning about collections.

I think there may be some very specialized situations where arrays are
computationally more efficient but for anything I write it's insignificant.
....but then ...with anything i write, what isn't?

 

Thanks for posting your solution, Dale. I really hate it when folks post
back that they 'found it' without letting others know what 'it' was.