(Solved) – How to I select a random empty cell from a range of cells, until all cells in range have been selected?

(solved)-–-how-to-i-select-a-random-empty-cell-from-a-range-of-cells,-until-all-cells-in-range-have-been-selected?

First time VBA coder here, so I’m not quite sure where to start.

I’m creating a “quiz” wherein a macro selects a random empty cell within a set range (C9:014). The user then types something into the cell and presses Enter. Then, the macro selects another empty cell within the set range (C9:O14). The user again types something into the selected cell and presses Enter. This process repeats until all 78 cells in the range have been filled by the user.

I suspect that some sort of Do Until loop is involved.

Does anyone have any ideas on how to do this?

Thanks so much guys.

Leave a Reply

Your email address will not be published. Required fields are marked *