Recent content by reeee

OK I have re-done my code, Im sorry but I didn't understand what was happening with what was suggested by yourself on the other page, this is my new code. It works perfectly but for some reason when I make a few changes to the cells within this same segemnt of code, solver just sits there but...

I don't understand what is actually being done with the code shown, are you saying that solver gets confused between sheets?

Can anyone help with this solver VBA code? basically it refuses to set the constraint for cells(106,3+chkcount) to 1 ****solveradd cellref:=Sheet1.Cells(106, 3 + chkcount), relation:=3, formulatext:=1*** If I change this to zero it works but not 1... Doesn anyone know why? I thought it was...

Managed to find out what the problem was, basically solver what calculating to a point where it made the total an illegal value i.e a minus number squared so I just added an IF statement that converted the cell to an obsene number basically telling solver to turn back and try another way. I...

Sorry about all this but I am new to Solver and it just doesn't make any sense, Im actually starting to wonder if my pc is broken. I have basically set up solver to do what I would like it to. In this example it should change the number to get the total cost to the minimum, it has to be greater...

OK, I have uploaded and example of whats going on, the row highlighted in red is what I want solver to change. The row in green is what must be kept above 45 otherwise the spreadsheet will kick out an error. The numbers solver chooses cannot be less than 0 otherwise the answer is wrong Hope...

sorry, It is a tad hard to explain really. I know that solver works as i have used it on other calculations but I just can't figure out why it won't listen to the constraints. in the row's selected in the jpeg, if I tell solver that the each value it chooses cannot be greater than 160 minus...

Hi, I am trying to use Excel solver to give me the minimum possible number for a problem that I have, the number selected in the jpeg attached are the ones that solver has been told to change so as to get the number shown as orange to it's lowest possible point. This number is worked out from a...