(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 *