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

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

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

These are not integers!

Pete

For a cell try:

=RAND()*0.4+0.05

or

N = Rnd() * 0.4 + 0.05

in the Macro
--
HTH

Sandy

with @tiscali.co.uk


"Jules" wrote in message
...
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

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

Pieter Vandenberg

Sandy Mann wrote:
: For a cell try:

: =RAND()*0.4+0.05

: or

: N = Rnd() * 0.4 + 0.05

: in the Macro
: --
: HTH

: Sandy
:
: with @tiscali.co.uk


: "Jules" wrote in message
: ...
: 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
: