Would someone here have this kind of program available (should be pretty simple/useful one): -Randomize a number between X and Y -Take an number of how many numbers to pick -Allow only uniques -Make sure that those are not on a list of denied numbers So something like Function RandomNumbers(X as integer, _ Y as integer, iHowMany as integer, _ vDenied as variant) as variant end function The key here is that Denied list, otherwise I would have it for example here: http://www.codetoad.com/vb_random.asp (I'm not sure if that works in VBA). Where does that "is denied?"-check take place on?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Pretty basic random picker

Thread starter Jaymond Flurrie
Start date Feb 24, 2011

Jaymond Flurrie

Well-known Member

Feb 24, 2011

Would someone here have this kind of program available (should be pretty simple/useful one):
-Randomize a number between X and Y
-Take an number of how many numbers to pick
-Allow only uniques
-Make sure that those are not on a list of denied numbers

So something like

Code:

Function RandomNumbers(X as integer, _
Y as integer, iHowMany as integer, _
vDenied as variant) as variant

end function

The key here is that Denied list, otherwise I would have it for example here:
http://www.codetoad.com/vb_random.asp (I'm not sure if that works in VBA). Where does that "is denied?"-check take place on?