Hi Leith,

Thank you for your help and explanation. When I tested the macro the extra statement solved the looping issue.

There is just one issue I am having now. The values in A1:A5 are calculated from other cells that have data validation. For example, cells B1:B5 only allow entry of numbers between 1-10.

When I entered an incorrect value in one of the cells (ex. 100), the macro recorded my values in A1:A5 three times. It ran once when I put in an incorrect value, a second time when I clicked "Retry" on the data validation error message, and a third time when I put in my corrected value. Is there a way to have the macro only record the last step- and correct values?

Best,

Katie