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.![]()
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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
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.
Here is the code I am attempting to use:
But an error message keeps showing up when the code is run. Hope you can help. Thanks![]()
Please Login or Register to view this content.
Last edited by JBeaucaire; 03-07-2013 at 10:39 PM. Reason: Added code tags, as per forum rules. Don't forget!
Assuming your lines of code are controlling the value of "x"
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks