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 the icon 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. ThanksPlease 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