Sub d2() '二维数组存入单元格
Dim arr, arr1()
Dim y As Integer
Dim x As Integer
y = Range("a65536").End(xlUp).Row - 1
arr = Range("b2" & ":c" & y + 1)
ReDim arr1(1 To y, 1 To 1)
For x = 1 To y
arr1(x, 1) = arr(x, 1) * arr(x, 2)
Next x
Range("d2").Resize(y) = arr1
End Sub
帮你把代码写全了,试试吧
Sub d2() '二维数组存入单元格
Dim arr, arr1()
Dim y As Integer
Dim x As Integer
y = Range("a65536").End(xlUp).Row - 1
arr = Range("b2" & ":c" & y + 1)
ReDim arr1(1 To y, 1 To 1)
For x = 1 To y
arr1(x, 1) = arr(x, 1) * arr(x, 2)
Next x
Range("d2").Resize(y) = arr1
End Sub
帮你把代码写全了,试试吧