My program runs really slow. And I was wondering if it is because I use like 500 statements like this

For i = 1 To 10000
X2.Worksheets(1).Cells(y, 7) = MagneticDrag4(x)
x = x + 1
y = y + 1
Next i

Is there a better way to write the entire array into a column?

Thanks,


JEFF