Redim Public Array variables
You can redim it all you want--but you can only change the size of the last
dimension.
Jarle wrote:
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
--
Dave Peterson
|