Hi Larry,

Thank you for the code. Working almost perfectly. I ran the macro for 75 multiple choice questions and is working great but as you said is "quick and dirty".

See if the following can be fixed.

In my sample, question 17 shows the correct answer (which is C) but it is ADDING the answer for question 18 right after the answer for question 17. It does the same thing whenever it finds answer A in a question. Therefore, every time there is answer A -is moving the answer to the previous question.

17. On December 31, 2010, xxxxxxxxxxxx?


A. January 1, 2014
B. January 1, 2015
C. January 1, 2016
D. December 31, 2015


Answer: C
Answer: A