View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wgaskill wgaskill is offline
external usenet poster
 
Posts: 5
Default Catching max iterations Stop of Solver in VBA

I would like to set up my macro so that if Solver does not converge at
maximum iterations, the Solver dialog is not displayed, and the macro
continues on with the best guess. Is there a way to turn off the dialog if
Solver doesn't converge?