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.