|
Sub jisuan()
arr1 = Array(0.91, 0.995, 1.003)
arr2 = Array(0.67, 0.718)
arr3 = Array(0.413, 0.501)
arr4 = Array(0.164, 0.259)
For x = 0 To UBound(arr1)
For y = 0 To UBound(arr2)
For Z = 0 To UBound(arr3)
For w = 0 To UBound(arr4)
k = k + 1
Cells(5, "j") = arr1(x)
Cells(6, "j") = arr2(y)
Cells(7, "j") = arr3(Z)
Cells(8, "j") = arr4(w)
Cells(k, "k") = Range("h9")
Next w, Z, y, x
End Sub
|
|