Html maker doesn't seem to work on my machine. (Win 98, Excel 97).
Initially there would be no data on a sheet, data would only appear once the code is run. Below is my short example (Range to apply data is A1:B2, 2 rows by 2 column instead of A1:E5, 5 rows by 5 column)
*************************************************************
Set1 ("A","B","C","D","E","F")
Set2 ("A","H","I","J","K","L")
Set3 ("A","N","O","P","QU","R")
Set4 ("A","T","U","V","W","X")
I'd like to randomly pick from each set then apply it randomly to the specified range (A1:B2)
So:
A1 = Can contain a string from one of the four sets
A2 = Can contain a string from one of the four but not in the set used in A1
B1 = Can contain a string from one of the four but not in the set used in A1 and A2
B2 = Can contain a string from one of the four but not in the set used in A1 and A2 and B1
*************************************************************