creating and re-creating 'random' numbers from a specific seed that can be recreated

I have an 4 x 23 array of random numbers currently made using randbetween. However, I want to be able to regenerate the exact same combination of numbers as needed.

Context: I teach high-school maths and use spreadsheets for generating random numbers or random questions. I have set up question for revision, where each student gets four random questions from a large set. I have the answers already created and so I would like to be able to access the answers for each student again based on the seed used to generate the random questions.

Great!
When I record that as a macro and drop it into some VBA will it work on a computer where the Analysis Tool Pack has not been installed?

...actually I found this thread:
http://www.excelforum.com/excel-prog...ndom-seed.html
in the Similar Threads below. It seems the site's Search-fu is better than mine. I now have this coding:

Please Login or Register  to view this content.