Help on arrays

[AutomationTester2011]

Code:

Dim work(2) work(0) = "Mon" work(1) = "Tue" work(2) = "Wed" Erase work ReDim work(5) work(3) = "Fri" PRINT work(4)

i have executed the above script and it is throwing error..i'm not sure why it is giving error..Can anyone correct the script

Thank you

[rajpes]

You should Redim at the time of array declaration as well

Code:

[b]ReDim[/b] work(2) work(0) = "Mon" work(1) = "Tue" work(2) = "Wed" Erase work ReDim work(5) work(3) = "Fri" PRINT work(4)

[AutomationTester2011]

Thanks for ur reply

but i'm declaring it as a static array and however would like to change the size of the array(dynamically)

Is it possible to change the static array into dynamic array

for ex:

Dim customer(30)
ReDim customer(50)

Is this correct?

[rajpes]

no not possible
but you could declare array in different way

Code:

work=array("mon","tue","wed") redim preserve work(5) work(3)="thu"