Redim on two dimentional array

[msherifam01]

Hi,

I want to create a 2 dimentional array which i want to update with loop.

the size will be decided while running the program.

How can i use redim and preserve each time when i insert values to array at run time.

[jindon]

See here

http://www.excelforum.com/excel-prog...crementer.html

[msherifam01]

Can u explain? i am new to vba

[jindon]

Explain what?

What do you not understand or what do you understand about Arrays?

[msherifam01]

Thanks for you help.
I found that in a multidimentional array only the last field can be redimensioned, i.e the right most.
Eg: NewArray(50, 20)
from the above example 50 remains fixed and 20 can be re-dimension.