Creating multiple, repeatable lists of random numbers

[WalkaboutTigger]

I am trying to create challenge/response cards. Each card will have a 5-digit number in the upper-left and lower-right corner along with a series of rows containing a line number and 3 pairs of challenge/response words.

Rather than have have copies of these cards, I want the central office to have a macro-enabled workbook wherein they can enter the two numbers from the card and have the challenge/response matrix regenerate on a worksheet.

So, essentially, I want the challenges random number generator seeded from one of the 5-digit numbers and the responses random number generator seeded from the other 5-digit number.

I am trying to use

Randomize(Seed)

where Seed is one of the 5-digit numbers.
The problem appears to be that, no matter what I use for Seed, the RND(-1) function is not resulting in different numbers.

Any assistance is appreciated.

I am using Excel 2007 and Excel 2010.

Thank you,

WT

 

[Jerry Sullivan]

This thread and the code example by shg might help. It could be the sequence in which you are using Rnd(-1) and Randomize fseed

http://www.mrexcel.com/forum/excel-questions/563155-can-you-seed-value-into-rnd.html