Question

I need to be able to create a newarray and assign it to another2darray(atsomeelement)

例

array1(0) = 1
array1(1) = 2

现在

array2(0) = array1

因此,

array2(0)(0) = 1
array2(0)(1) = 2

现在,我想拿出一个新的阵列,把1个阵列分配给它。

newarray = array2(0)

因此,

newarray(0) = 1
newarray(1) = 1

I cannot do this in VBA code.
Code snippet below, works if you comment out the last section where I try and assign array2(1) to arraynew.

Function test()
    Dim array1(0 To 20) As String
    Dim array2(0 To 5) As Variant
    Dim count As Integer

    For count = 0 To UBound(array1)
     array1(count) = count
    Next count

     now that array1 is filled i want to insert it into array2(1)
    array2(1) = array1

      test
    MsgBox (array2(1)(3))

     now i want to create a new string array and assign it to array2(1)
    Dim arraynew(0 To 20) As String
    arraynew = array2(1)
     this is what fails. 

End Function

Answer 1

我们不能指定固定的阵列。声明它是一种动态。

Dim arraynew() As String
arraynew = array2(1)

友情链接