"Michael C" <nospam@nospam.com> wrote in message
news:uneBdwPDHHA.4256@TK2MSFTNGP04.phx.gbl...
> "fniles" <fniles@pfmail.com> wrote in message
> news:OlkQffPDHHA.652@TK2MSFTNGP02.phx.gbl...
>>I need to store information in a 2 dimensional array. I understand
>>ArrayList only works for a single dimensional array, is that correct ?
>> So, I use the 2 dimensional array like in VB6. I pass the array into a
>> subroutine, and inside it I "Redim Preserve" the array to increase the
>> number of item in the array. I got the error "Redim statement requires an
>> array", but arr is an array. HOw can I fix this problem ? Or, how can I
>> do ArrayList for 2 dimensional array ?
>> THank you very much.
>>
>> Private arr(COM_MAX, 0) As String
>> LoadArr(arr)
>>
>> Sub LoadArr(ByRef arr As Array)
>
> Pass it in the same way you define the array, eg
>
>> Sub LoadArr(ByRef arr As int(,))
>
> BTW, redim preserve does a complete copy of every element in the array
> every time it's called. In your loop that will mean half a million copies
> for each column.
>
> Michael
>

"fniles" wrote:

> I need to store information in a 2 dimensional array. I understand ArrayList
> only works for a single dimensional array, is that correct ?
> So, I use the 2 dimensional array like in VB6. I pass the array into a
> subroutine, and inside it I "Redim Preserve" the array to increase the
> number of item in the array. I got the error "Redim statement requires an
> array", but arr is an array. HOw can I fix this problem ? Or, how can I do
> ArrayList for 2 dimensional array ?
> THank you very much.
>
> Private arr(COM_MAX, 0) As String
> LoadArr(arr)
>
> Sub LoadArr(ByRef arr As Array)
> lNumComm = 0
> For x = 1 to 1000
> ReDim Preserve arr(COM_MAX, lNumComm)--->Redim statement requires an array
> :
> next
>
>