Ok... I have an array, it's nice'n redimmable.
It starts as size.
I then pass it into an array byReference
It comes back, and I do a for each loop on it, msgboxing each value
I've only populated the first 3 values of the array, so I get the 3 values, then 13 more blank message boxes?! Yet ubound of the array still stores 15. Oh well, no big deal there. I couldn't care.
However, if I pull a Redim array(3) within my function, I get 4 messageboxes (still one more, what the heck?... and yes I'm sure it's not an errant messagebox from elsewhere, I have a unique bit of text in each one that's not changing)
But more perturbing, all 4 are blank... that's my big issue, I want to redim it to the size I want, without dropping the values.... any ideas?
-Rob
It starts as size.
I then pass it into an array byReference
It comes back, and I do a for each loop on it, msgboxing each value
I've only populated the first 3 values of the array, so I get the 3 values, then 13 more blank message boxes?! Yet ubound of the array still stores 15. Oh well, no big deal there. I couldn't care.
However, if I pull a Redim array(3) within my function, I get 4 messageboxes (still one more, what the heck?... and yes I'm sure it's not an errant messagebox from elsewhere, I have a unique bit of text in each one that's not changing)
But more perturbing, all 4 are blank... that's my big issue, I want to redim it to the size I want, without dropping the values.... any ideas?
-Rob