Howdy,

Thanks to all for the great responses.

In an unscientific test, both (Tom and JE) methods appear to be about equal,
if you turn off the screen update. They are pretty close to equal with
screens update on, with Tom's updating twice. Either way, they are less than
5 seconds for 25k x 50.

Regards
TB

"Tim Bieri" wrote:

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