All the values get written into the same cell and the macro runs so fast you don't see anything until it has completed.
If you want to write to different cells change the location for each value of A
eg.
cells (num,1) = A
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|