Dear excel fam.,
I am trying to optimize a function f(x,y,z) thanks to the solver, One of the constraints depends on a parameter B (integer), say x*y=B.
I want to loop over different values of B and get the value of f. This is what I did thanks to a for loop, however, at each single loop, excel displays a msgbox saying that it founds the solution, this msgbox stops the calculations, I need to click ok so it continues the loop and so on.
My question is: is there anyway to say to excel to never display that msgbox ?
Thanking you in advance life savers,
Houssame,
I am trying to optimize a function f(x,y,z) thanks to the solver, One of the constraints depends on a parameter B (integer), say x*y=B.
I want to loop over different values of B and get the value of f. This is what I did thanks to a for loop, however, at each single loop, excel displays a msgbox saying that it founds the solution, this msgbox stops the calculations, I need to click ok so it continues the loop and so on.
My question is: is there anyway to say to excel to never display that msgbox ?
Thanking you in advance life savers,
Houssame,