Hi All,
Trying to build an excel VBA macro but just getting my feet wet with the tool.
So far I have this:
Sub Loop_Until()
x = 17
Do Until Cells(x, 7) = 200
ActiveCell.FormulaR1C1 = ""
Range("J16").Select
Loop
The purpose of this Macro is to loop until the combinations of either summing or not summing a string of numbers equals the value 200.
I used Randomization because I could not think of a complex matrix structure that would solve this more efficiently, so I'm going the brute force route.
Any ideas because as the string of variables get longer the time it takes to solve gets exponentially longer?
Thanks in advance for your help!
Bookmarks