For the life of me I can't remember how to clear a 2D (actually any-D) array. I have this "Dim aryList" and then I define it's size later as "Redim aryList(1 to 200, 1 to 3)". I populate this array twice for two different purposes so I'd like to reset it to only be the size of how many items I added (which I do in a For Loop). I kept a count of what I did add, say 120, so do I do "Redim Preserve aryList(1 to ct, 1 to 3)" where ct is the known count of how many elements are stored?
Also, how do I just clear it out completely? I tried aryList = nothing and a few other variations but they failed. Actually I just had an idea (dangerous I know) about creating a dummy, unused range (Dim rngNone as Range) and assign that to aryList (since it's really a range, right?)
aryList = rngNone