Clearing (not erasing or deleting) contents of Variant array

[welchs101]

I have a variant array and i define it initially like the following:

Please Login or Register  to view this content.

I want to "clear" the contents of the array and start over populating it with other values. But i want the qty of entries in the array to stay the same.....and the data type as well.

Please Login or Register  to view this content.

i tried the following code but when it gets to the "2nd" For statement i get a run time error.




I found this code to clear the array on line. The code used a slightly different array type but i thought i could still use this with my variant type array. Her eis the orringal code which does not crash.

Please Login or Register  to view this content.

[Steffen Thomsen]

Hi,

try changing this

Please Login or Register  to view this content.

To this

Please Login or Register  to view this content.

Steffen Thomsen

[welchs101]

nope.....that did not work either............i think it might have something to do with this array being defined as variant and the other one as an integer......not sure........

[Steffen Thomsen]

Hi,

If you set the array later on with a range then try waiting to then with the redim

Then use

Please Login or Register  to view this content.

This way you just overwrite the values in the array with the values of the new range

Steffen Thomsen

[welchs101]

Steffen Thomsen good suggestion. However, i really wanted to just know how to "clear" the contents of the array........but i really like your suggestion.

I figured out my problem...........my array is 2 dimensional so i had to do a redim in the following manner

Please Login or Register  to view this content.

if you do this the arrays contents get zeroed out.

[shg]

1. Redim resets the elements of a Variant array to Empty, not 0.

2. Unless you have set Option Base 1, your code redimensions the array to (0 to 26, 0 to 1)

But I can't envision why this would be necessary.