goal seek questions

[rogernz]

When running a goal seek fuction from an equation, occasionally the equation will not be able to reach the required value as the equation curve will never reach that value - is there a vba goal seek equivalent, or an error handler I can use to halt the process of goal seek when used in a looping sequence. I have a code that runs, however when it encounters the point in the code where the equation will never reach the value, I want the code to either stop, or to more closely define the calling values so I can find the end point.

I input a vehicle wheelbase, and return the maximum or minimum chassis rear overhang to reach max stress. All this I can do and I can make it loop though a series of wheelbase iterations and return the rear overhang for each case, just need and error handler or a vba equivalent etc.

Thanks

 

[Andrew Poulsom]

The GoalSeek method returns True if successful, otherwise False.

 

[rogernz]

Can you control the number of iterations for the goalseek method?, ie if it doesn't find a solution after 50 attempts it returns a false

 

[Andrew Poulsom]

You can't control the number of iterations with Goal Seek, but you can with Solver.

 

[rogernz]

Cool, thanks, will do some fiddling and see what works - I want to use an interupt on the looping code if it cannot find the value the solver or goalseek function is searching for - what is the best way to do this?