loop that stops when certain value is obtained

I require a loop that calculates the values in successive rows until a certain value is reached in one of the cells in a row. Thank you.

You're welcome. We require a lot more information than that to offer anything specific.

I am writing a macro for a loan schedule that must end when the loan has been cleared (i.e the value of the ending balance is 0) How do I write a macro using a loop that stops when this occurs, but the range of the cells is unknown. I hope this helps, if any more info is required please feel free to ask

Picture yourself looking at a spreadsheet you've never seen before... what questions would you ask? If you're not going to upload a sample workbook to show us, you have to describe it all. We don't know anything yet.

Assuming your lines of code are controlling the value of "x"

Please Login or Register  to view this content.