Looking at the values in your uploaded file there is some strange values.
Cell B30, the number is formatted as text as well B35 and B52. The numbers in B31 and B32 is given as 1.8 and 0.05 where I would have expected 1,8 and 0,05
Opening up Solver see uploaded jpg you do have a number of constraints i.e. "Freeboard <= 1,5" and "Freeboard >= 1,5" so in this macro the line
is missing and I'm not sure I understand the logic behind "Freeboard <= 1,5" and "Freeboard >= 1,5"
solv_problem.jpg
The macro "Sub Solver4" could do with a bit of trimming, not wrong the way it's written but perhaps easier to read i.e.
Alf
Bookmarks