VBA-Stuck in loop.

[James824]

Hi, so I currently have a loop that fails to stop if the target condition set is impossible to meet.

I have a sheet "system" that is fed by information from "subsystem 1", "subsystem 2", "subsystem 3" and so on (each subsystem sheet is based off the same template). The user can add as many subsystems sheets as they need. Within the subsystem sheets there are components (again can have as many rows required by the user).

I would like to implement the condition that if the sum(I7 to end of row), so a variable range from I7 down to I"", equals zero on any subsystem sheet then the loop ends.

I wonder if anyone would be able to offer any potential ways to implement this? I am new to VBA and I am just trying to get my head around what is going on.

Any help with this would be greatly appreciated.

Many thanks,
J

 

[GWteB]

I am new to VBA and I am just trying to get my head around what is going on.

Then you might be interested in the contents of this article, in particular the "Debugging" section ...

Short Guide to Better VBA

Following are some guidelines to improve your VBA skills and macro writing. Writing macros in Excel uses Visual Basic for Applications (VBA) and so in a way you are programming. As with nearly all programming languages this means you have to use a logical approach and be accurate. VBA has a...

www.mrexcel.com

 

[James824]

That's great thanks! I have reviewed this along with a few videos and feel like I have grasped the method for de bugging.

I believe my issue is with the start of the "Do Until" command.

I currently have "Do Until minVal > Target_Reliability" and I believe that I need to add to that.

I think something along the lines of "Do Until minVal > Target_Reliability OR" and then adding in vba language for "the sum of I7 to row end = 0 for any subsystem sheet"

would you happen to know how to write this in VBA?

Many thanks,
J

 

[GWteB]

I understand you already have some code (working or not). Would you like to post it?

PS: please use code tags ...