Steve wrote on Tue, 6 May 2008 14:01:20 -0700 (PDT):

HYCH

I am using the code below to run a randomsier, but i would
like to randomly generate numbers from 1 to 128 and put them
into cells in column B ie

1st number generated into b1, 2nd number would then go into
b2, 3rd into b3 and so on, any help with the code for this, if
it is possible

Random code using just to show a random number.

Sub RandomNo()
Randomize
MyNumber = Int((128 - 1 + 1) * Rnd + 1)

If you just want random numbers between 1 and 128 use
RANDBETWEEN(1,128) If you want 128 unique random numbers, put
1:128 in col 1, =Rand() in col 2 and sort on col 2 as one
solution.

--

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not