Looping through different DV scenarios and ending on a certain one

Hi there,

I'm using the following code to loop through three scenarios in a workbook and paste the output of each on a results page:

Set rCopy = Worksheets("Returns").Range("C32:D36")
Set rDest = Worksheets("Macro Output").Range("C3")

Set dvCell = Worksheets("Assumptions").Range("A1")

For Each Cell In Split(dvCell.Validation.Formula1, ",")
dvCell = Trim(Cell)
Call InterestCalculations
rDest.Resize(rCopy.Rows.Count, rCopy.Columns.Count).Value = rCopy.Value
Set rDest = rDest.Offset(, rCopy.Columns.Count)
Next Cell

The data validation cell contains three scenarios - 1, 2, and 3. The first scenario represents actual expectations, while the others reflect outperformance and underperformance. The macro works fine, but when I run it, the loop stops while the data validation cell is at 3. Since scenario 1 is the primary output, I'd like for the data validation cell to reset to 1 whenever the macro has finished running. What can I add to the end of this code to make that happen?

I'm using Excel 2019 on a 64-bit system.

Thanks in advance!

Thanks, Robert. I actually had declared my variables but accidentally excluded them from the code snippet I posted! I had this idea that using that last command might mess up the loop so I never even tried it - simple, but effective and seemingly obvious! Thanks for letting me know about the posting rules and thanks again for the quick response - greatly appreciated.

-WT