Hi Tim,

try:

For Each cell In Range("name")

cell.Formula = "=RND()"

Next cell


Thats even shorter ;o)

Best

Markus


>-----Original Message-----
>Howdy,
>
>I would like to generate a random number in a named
range. The named range
>would have a variable size (up to 25000 row and 50
column). I know that I
>can copy/paste RND() in all the cells, but I am
interested in generating the
>number. Using RND(), I would have to copy paste values
so they would not
>change. I am also concerned about looping that many
times and how long that
>would take.
>
>Is there an easy way to essentially populate a 2-D array
from a random
>function?
>
>Regards,
>TB
>
>.
>