I am pretty much VBA ignorant. A kind gentelman helped me make a loop a few months back for a brewing spreadsheet that I made. The loop is fucntional, but I would like to modify it if possible. The loop is set up to make two cell values equal each other by adjusting the value of a third cell. To accomplish this 100% of the time, I had to set the loop to make adjustments in increments of .0001. The problem is, sometimes it can take quite a while for the computation to complete. If I set the loop to adjust in increments of .001, it is always able to get the two values in question within .01 of each other and the computations run a lot faster. For my purposes, a difference of .01 is insignificant. Is there a way to make the loop stop running when the two values get within .01 of each other istead of having to make them equal? Here is the coding I am working with.
![]()
Please Login or Register to view this content.
Bookmarks