Looping Solver in VBA

[cmondeau]

I'm trying to create a basic 1D cutting optimizer using Solver in VBA. However, I keep getting hung up when I try to implement Solver in a loop. I've allowed myself a few criteria to follow by, which I believe I have achieved in my code so far. Any help at all would be greatly appreciated!

Goal: Minimize the amount of stock pipe used
By Changing: Changing the amount of predetermined lengths of pipe to be cut per stock piece
Constraint 1: Each Cut length cannot exceed the maximum length of stock pipe (21')
Constraint 2: All pipes spooled must be used in the optimization template
Constraint 3: All values of pipe must be rounded to the nearest whole number
Constraint 4: If the the amount of pipes exceed the capacity of the stock pipe, additional stock must be added to the order

Currently I have 2 command buttons to complete my task, but eventually I would like to make it run with just one. I'm not super good with programming and some concepts, but have taken a couple of classes and done independent research to get myself along. Thank you for your help!

Please Login or Register  to view this content.

[cmondeau]

Instead of looping, I think i might try creating a range of cells that I can have solver find and fill within VBA. Here is my code so far, but when I run it I get,"Error in model. Please verify that all cells and constraints are valid."
Not sure where my mistake is :/

Please Login or Register  to view this content.

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules about cross-posting.

Thanks.