If you list the prime numbers in a column, you can randomly retrieve
them with this technique:

http://www.mcgimpsey.com/excel/randint.html


In article ,
"johnT" wrote:

my kid brought home a prime number puzzle that i'm trying
to work out using excel....we have 5,7,11,13,17,19,23 in
the form of an H such that the 2 columns and the 2
diagonals add up to the same prime number....i was
thinking of writing a VB program to solve this but i'm not
sure how to randomly generate this set of prime numbers,
any ideas.....thx