Sorry WarPiglet, I was thinking about a different project I am doing.

What I am looking for is this. A macro "random number generator" with NO REPEATS in a ROW that will generate number combinations by a selected number and only by that number I select for the combinations to begin with. I would like to be able to be able to change the range of the combination range 1-53 that the number pool is drawn from and also how many combinations the macro will produce, let say I want 100 combinations today but tomorrow I would like to have 500.

Example... number range 1-59, length of string 6, by the number 8, at 250 combinations.

So the macro would produce number combinations within the range 0f 1-59 BUT they would start at the number "8",which mean any number lower then "8" would not be in the combinations. Then give me 250 number combinations ALL starting AT "8"

8-5-23-24-35-52

8-11-15-31-40-49

8-21-30-36-45-53

The variables for the Marco are this...

1.) number range can be changed..1-49,1-53,1-59,1-75

2.) combination length can be changed to either 5 or 6 numbers in length

3.) a selected number be it any number (1-2-3-4-5-6-7-8-9-10-11-12-13-14-15...etc.) can be selected to START the combinations, thus ANY number below the selected number to START the combinations with, will not be included in the combinations. So if I want to have combinations STARTING at 9 ALL numbers below 9 are not including in the combinations.

4.) The total amount of the combinations produced by the macro can be chosen. 50,150,225,300,500,1000 total combinations.

Does this help?