random numbers

[Guest]

I'm running a macro which(using a For Loop), inputs the results from certain
calculations into a row and then carries out the same process entering the
data into the next row for 100 rows. The calculations involve using a random
number which has been generated in a different cell. I need a different
random number to be generated each time the calculations are done. At the
moment the random number is the same for each row.

Any advice on how to amend this without having to creat a list o f 100
random numbers?

Many Thanks

 

[Guest]

Are the random numbers from 0 to 1 or are they randomly selected integers in
some range?

 

[Guest]

they are random integers in the range 0.05 to 0.45

 

[Pete]

These are not integers!

Pete

 

[Sandy Mann]

For a cell try:

=RAND()*0.4+0.05

or

N = Rnd() * 0.4 + 0.05

in the Macro
--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[vandenberg p]

If I understand the question I belive a: Application.Calculate
inside the loop would do it.

Pieter Vandenberg

: For a cell try:

: =RAND()*0.4+0.05

: or

: N = Rnd() * 0.4 + 0.05

: in the Macro
: --
: HTH

: Sandy
: (e-mail address removed)
: (e-mail address removed) with @tiscali.co.uk


: :> they are random integers in the range 0.05 to 0.45
:>
:> "Gary''s Student" wrote:
:>
:>> Are the random numbers from 0 to 1 or are they randomly selected integers
:>> in
:>> some range?
:>> --
:>> Gary''s Student
:>>
:>>
:>> "Jules" wrote:
:>>
:>> > I'm running a macro which(using a For Loop), inputs the results from
:>> > certain
:>> > calculations into a row and then carries out the same process entering
:>> > the
:>> > data into the next row for 100 rows. The calculations involve using a
:>> > random
:>> > number which has been generated in a different cell. I need a different
:>> > random number to be generated each time the calculations are done. At
:>> > the
:>> > moment the random number is the same for each row.
:>> >
:>> > Any advice on how to amend this without having to creat a list o f 100
:>> > random numbers?
:>> >
:>> > Many Thanks
:>> >