Hi there
An abbreviated version of my problem is that i have a set of 4 numbers for example (1, 2, 3 and 4) and i would like to be able to have an object which holds these 4 numbers where any one of them can be randomly chosen. If, lets say, 2 is randomly chosen, then i would like that the number 2 be excluded from the set (object) and another random selection occur between the numbers 1, 3 and 4. This needs to continue until only one number is left in the set, thus producing a sequence 2,3,4,1 for example.
Can anyone please provide some information on how to create such an object in VBA and how to perform the random selection so that the latest selction is excluded so that the set gets smaller and smaller until there is only one integer left.
Any help or direction is much appreciated.
Thanks
Steve
An abbreviated version of my problem is that i have a set of 4 numbers for example (1, 2, 3 and 4) and i would like to be able to have an object which holds these 4 numbers where any one of them can be randomly chosen. If, lets say, 2 is randomly chosen, then i would like that the number 2 be excluded from the set (object) and another random selection occur between the numbers 1, 3 and 4. This needs to continue until only one number is left in the set, thus producing a sequence 2,3,4,1 for example.
Can anyone please provide some information on how to create such an object in VBA and how to perform the random selection so that the latest selction is excluded so that the set gets smaller and smaller until there is only one integer left.
Any help or direction is much appreciated.
Thanks
Steve