Redim Public Array variables

J

Jarle

I have an Array that defined as Public variable.
In procedure1, I Redim this variable and input data.
I procedure2, I try to Redim once more in order to input more data in the
same array.
Is there any way to do this, or will it be impossible to Redim an Public
Array after the initial definition?
Ideas, tricks?

I use procedure below.

Public Arrayname() as String' () in order to define dynamic Array

Sub Procedure1
Redim ArrayName(1 to 10, 3)
' Then I input data into this array
End Sub

Sub Procedure2
Redim Preserve Arrayname(1 to 20,3)
'Input data
End Sub
 
D

Dave Peterson

You can redim it all you want--but you can only change the size of the last
dimension.
 
T

Tim Zych

To get that to work, modify the array:

Redim ArrayName(3, 1 to 10)

The last dimension is the one that can be preserved.

Then this will work:

Redim Preserve ArrayNames (3, 1 to 20)
 
A

Alan Beban

Jarle said:
I have an Array that defined as Public variable.
In procedure1, I Redim this variable and input data.
I procedure2, I try to Redim once more in order to input more data in the
same array.
Is there any way to do this, or will it be impossible to Redim an Public
Array after the initial definition?
Ideas, tricks?

I use procedure below.

Public Arrayname() as String' () in order to define dynamic Array

Sub Procedure1
Redim ArrayName(1 to 10, 3)
' Then I input data into this array
End Sub

Sub Procedure2
Redim Preserve Arrayname(1 to 20,3)
'Input data
End Sub
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

ResizeArray ArrayName,,20

Alan Beban
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top