Array in VBA

[Piotr Nowak]

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

 

[Jurgen]

Hi
How can I change the size of array in VBA ?

Use the "redim" statement the change the size.
eg
Dim MyArray(2,2) as string
ReDim MyArray(5, 5) as string

Use "redim preserve" if you want to keep the data stored in the array after
resizing it. Note that you can only change the LAST dimension when using
"preserve"

succes,

 

[Piotr]

Hi Jurgen
Thanks, but is it possible to STATIC arrays ?
I get the error, but when I use dynamic arrays it's oki.

Best regards,
Piotr

 

[Tushar Mehta]

As Jurgen pointed out, use ReDim. However, the example is not correct.
One cannot redimension an array declared with specific bounds. Use
something like:

Sub testIt2()
Dim MyArray() As String
ReDim MyArray(5, 5) As String
End Sub

--
Regards,

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

 

[Tushar Mehta]

Also check the responses in .excel.programming.

--
Regards,

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