Changing a table of values with random nrs

[ylijohe]

I need a function to test a program.

A table should be filled with random numbers.
Any smooth solutions?

 

[Yogi Anand]

On 2002-09-29 09:57, ylijohe wrote:
I need a function to test a program.

A table should be filled with random numbers.
Any smooth solutions?

How about entering in the first cell of the table... =RAND(), then highlite the extent of your table and then do CTRL+ENTER ...

your table will be filled with random numbers

see the worksheet simulation ...

y020929.xls
	A	B	C	D
2
3	0.71596	0.654192	0.032758
4	0.930957	0.136261	0.430818
5	0.271726	0.829464	0.380533
6	0.421402	0.799811	0.150816
7	0.379914	0.344931	0.781324
8	0.594127	0.133817	0.430824
9	0.337332	0.147832	0.072618
10	0.396643	0.639039	0.209252
11
Sheet13

</SPAN>

Regards!

Yogi

 

[ylijohe]

Good, but actually i need a macro to run the same procedure when needed, and I have to watch the count to progress on another sheet. This helps anyway, because now I can make a macro to do this job for me.

Thankyou.