Hi all,
With a lot of help from the forum, I've got myself an array containing cell addresses.
My next step in handling this data would be to pick from this list of addresses at random. I need to be able to control how many are picked (only likely to be 1 to 2 addresses) and for those picks to be unique in the case of 2 picks.
I'm not actually sure if this is possible or not - though I assume there must be a way of fudging it even if VBA isn't designed to do anything at random.
I'm imagining some sort of randbetween the ubound and lowbound of myArray - but I'm not sure on much beyond that.
Thanks all!
Edit: Should probably explain what I'm trying to do with the random cell address/addresses once they've been picked. They'll be given a .value from another variable - if its two picks, they're both the same .value
With a lot of help from the forum, I've got myself an array containing cell addresses.
My next step in handling this data would be to pick from this list of addresses at random. I need to be able to control how many are picked (only likely to be 1 to 2 addresses) and for those picks to be unique in the case of 2 picks.
I'm not actually sure if this is possible or not - though I assume there must be a way of fudging it even if VBA isn't designed to do anything at random.
I'm imagining some sort of randbetween the ubound and lowbound of myArray - but I'm not sure on much beyond that.
Thanks all!
Edit: Should probably explain what I'm trying to do with the random cell address/addresses once they've been picked. They'll be given a .value from another variable - if its two picks, they're both the same .value
Last edited: