Hi Experts, I think this an easy one, but I'm having trouble figuring it out... I have a one dimension array with about 500,000 values that I need to dump into an excel column quickly. I'm currently using the code:
For x = 1 To UBound(N_Data)
Cells(x + 1, Last_Col) = N_Data(x)
Unfortunately this is very slow. When I try to simply select the range and set the value equal to my data i.e.:
Range(Cells(2,Last_Col),Cells(Ubound(N_Data)+2),Last_Col)) = N_Data
it dumps blank values. I think this is because the values in my array need to be transposed...