I have a particular Goal Seek formula that occasionally runs into astronomical values so I'm told to use Solver instead to limit the result. I don't know enough about Solver to be able to convert what I have in Goal Seek to Solver and add in an upper limit to the calculation.

Can someone help change the following line into Solver VBA code and set the limit of the output to 99,999,999 and/or when approaching or hitting this limit, provide an error message instead? 

Please Login or Register  to view this content.