and one more

Sub GenRandom()
With Range("MyRange")
.Formula = "=rand()"
.Formula = .Value
End with
End Sub
Doesn't require any looping and the numbers produced won't change.
Nonetheless, it may be slower than JE's solution depending on how
calculation gets involved. I don't know since I haven't tested it.

--
Regards,
Tom Ogilvy

"Tim Bieri" <tbieri@gci.net> wrote in message
news:BE302ADF.10ED%tbieri@gci.net...
> 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
>