EXCEL中用宏编写数组的问题

2025-03-05 10:25:01
推荐回答(1个)
回答1:

可以改成:
Sub test()
Dim x(1 To 11) As Single
Dim y(1 To 11) As Single
Dim i As Integer
n = 1
For i = -10 To 10 Step 2
x(n) = i
Cells(n, 8) = x(n)
y(n) = x(n) ^ 3 + x(n) ^ 2 + x(n)
Cells(n, 9) = y(n)
n = n + 1
Next
End Sub