goal seek questions

rogernz

Board Regular
Joined
Jul 21, 2004
Messages
93
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
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

rogernz

Board Regular
Joined
Jul 21, 2004
Messages
93
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
 

rogernz

Board Regular
Joined
Jul 21, 2004
Messages
93
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?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,888
Messages
5,766,948
Members
425,389
Latest member
Naresha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top