Give this subroutine a try...

"Diogo" wrote in message ...
Hi

Need help with the following:

I've a cell that is calculated with the random function

I need a procedure that simulates me hiting the F9 button and copying the
result to a column so I can make a statistic to see how many values are above
a certain value? lets say I need 100 values to have a representative sample.
How can I make this?

Please help. Thanks.