T
Tim Bieri
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
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