Hi,
I have a range of 100 cells consisting of numbers, arranged in a 10x10 format. I need to randomly choose one cell and remove the number in it from the pool. I have to keep repeating the process until all 100 numbers have been selected. In other words, I can't select a cell twice and the pool shrinks after each selection.
How can I create a macro to do this process in the most efficient manner?
Thanks
I have a range of 100 cells consisting of numbers, arranged in a 10x10 format. I need to randomly choose one cell and remove the number in it from the pool. I have to keep repeating the process until all 100 numbers have been selected. In other words, I can't select a cell twice and the pool shrinks after each selection.
How can I create a macro to do this process in the most efficient manner?
Thanks