• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

recording macro for solver

sarvesh

New Member
i have to run solver on four different sheets. output of 1st sheet will be used as input of 2nd and so on. i have recorded a macro to run the solver for all 4 sheets one by one. but when i run the macro it stops at every sheet and ask to enter manually to confirm "keep the result". can anybody help with this.
 
Hi Sarvesh,


Before you cal the Solver in the macro insert the following


Application.DisplayAlerts = False


make sure that at the end of your macro you reset it by including the code


Application.DisplayAlerts = True


cheers


kanti
 
thanks Kanti. i tried your suggested method but could not fix the problem. at the same time stuck with another issue. i have made an excel optimizer sheet using solver. this sheet was working fine till i uses 10 data sets. as i fill in with 50 data sets it goes haywire. to explain this i need to chat wid u. if you are comfirtable we can chat on gmail id. my ID is sarvesh.nifft@gmail.com. can you pls help?
 
Back
Top