VBA to change Array Length!

Hi guys, How can I change the array size when I want to add an element?

Please Login or Register  to view this content.

This code give me an error message, which is "Compile Error: Array Already Dimensioned".

check out this

Please Login or Register  to view this content.

if you just redim all previously assigned values will disappear (try to remove Preserve from second redim and check what is arrMy(1) at the end

Its still the same, we cannot redimension the array after we already dimensioned it...

Or anyone know how to delete the array arrMy(), so we can dimension it one more time.

Sorry Kaper, your code work!

Thanks you so much, really don't know the meaning of Dim and Redim!

I think i have to study more about it.