Array in VBA

[Piotr]

Hi
How can I change the size of array in VBA ?
Is it possible to change static array or dynamic array ?
Please, help me.

THANKS !

Best regards,
Piotr

 

[Bob Phillips]

Dim ary, i

ReDim ary(1 To 5)
For i = 1 To 5
ary(i) = i
Next i
MsgBox ary(5)

ReDim Preserve ary(1 To 6)
ary(6) = 6
MsgBox ary(5)
MsgBox ary(6)

 

[Andibevan]

Try sticking Dynamic Array Excel VBA into google......

 

[Piotr]

Ok, THANKS !!!

Best regards,
Piotr

 

[Piotr]

Ok, THANKS !!!

Best regards,
Piotr

 

[Tushar Mehta]

Also check the responses in .developer.vba

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Alan Beban]

Dynamic array, yes; static array, no. What do you want to change? From
what to what?

Alan Beban

 

[Piotr]

In one dimension there is no problem.
If I have twoj dimensions or more... I lose my data - but If I use ReDim
Preserve I won't lost data only in the last dimension ?
Is there any other possibilities ?

Best regards,
Piotr

 

[Alan Beban]

Let me try again. What do you want to change from what to what? Perhaps
you could give a simple illustration of what you are trying to achieve
in a two-dimensional array.

Alan Beban

 

[Piotr]

Hi Alan
I havn't any real problem - I learn VBA and I'd like to know all
possibiliteis about changing size of arrays. Sorry if my questions are
stupid :-(

Best regards,
Piotr

 

[Alan Beban]

No, no! Not stupid at all. I'm just trying to get a fix on exactly what
you are trying to accomplish.

You might want to review the Sub Procedure ResizeArray in the freely
downloadable file at http://home.pacbell.net/beban

Alan Beban