For Example,
From column A1 to A20 I assign 20 random numbers (A1=rand(), A2=rand(),
... A20=rand()).
Then I put B1=sum(A1,A2,...,A20)
Every time I press "F9", I got a outcome of B1
Now I want to get the outcome 1000 times, and assign the data to other
columns such as C11 to C10000. How to do that?


--
vegas
------------------------------------------------------------------------
vegas's Profile: http://www.excelforum.com/member.php...o&userid=25091
View this thread: http://www.excelforum.com/showthread...hreadid=386025