Hello everyone,

I could use some help from y'all. I have a macro that is going to loo
through the range (A1:A100), and use the number in that particular cel
to fill in range(B1:B100) with the corresponding question. Now, what
need help creating, is a random number generator to fill in th
range(A1:A100) with a random number. There are approximately 50
questions that will be available, so I don't want it to use the sam
question twice. How can I create a macro to randomly generate a numbe
from 1 to 500 and enter them into range(A1:A100) and not using the sam
number again...

Any help will be greatly appreciated

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=48472