|
请问如下赋值为什么会出错,正确的应该怎么写
Sub test()
Dim arr(1 To 15, 1 To 2) As Range
Dim i, j, k, x
For i = 1 To 5 Step 2
For j = 1 To 5
x = x + 1
arr(x, 1) = Range(Cells(j, i)).Value
arr(x, 2) = Range(Cells(j, i + 1)).Value
Next j
Next i
End Sub
问题1,变量设置为range。。。赋值的是单元格的值。。。
问题2,range和cells重复使用了。。。
Sub test()
Dim arr(1 To 15, 1 To 2)
Dim i, j, k, x
For i = 1 To 5 Step 2
For j = 1 To 5
x = x + 1
arr(x, 1) = Cells(j, i).Value
arr(x, 2) = Cells(j, i + 1).Value
Next j
Next i
End Sub
这样就可以了。。
|
|