I wrote a multiple choice tests in excel, it's 7 pages multiple choice with
in cell pull down answer selections. It's also timed which affects your score
if your fast or slow. It also keeps track of the top 10 scores. It has 6
macros that record the time, hide the sheet your one and open the next sheet.
The scores, including times and top 10 are listed on the final sheet which
is just a total sheet. It works perfectly up to that point -- I tried to
record one last macro to reset it ie add new results to top ten list -- print
totals, clear answers, and save it blank on the first page ready for some
one else to take. The final macro I have written about 6 times I hit record
do everything I want it to do, but when i run it, it randomly clears most of
the cells on the total sheet. The total sheet is not selected when I'm
clearing the others. I know it's a lot to ask but I'm going crazy can someone
steer me in the right direction ?