Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Redim Public Array variables
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ReDim an array | Excel Programming | |||
ReDim Array | Excel Programming | |||
ReDim Object array as parameter of Variant array | Excel Programming | |||
Dim / Redim of an Array | Excel Programming | |||
ReDim an Array | Excel Programming |