Excel Goal Seek vs. Solver

[Adrian T]

Does anyone have a recommendation for Goal Seek vs. Solver in terms of
execution speed? I read somewhere that Solver was a little faster than Goal
Seek but when I used it though VBA, it seems slower.

Thanks,
-Adrian

[Tushar Mehta]

What is faster is often very subjective. If I were in your shoes and
if speed was relevant -- which is often *not* the case -- I'd go with
whatever was faster for me in my environment for my problem.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <9D43795E-481F-4523-8B98-63ABCE62EF1C@microsoft.com>,
AdrianT@discussions.microsoft.com says...
> Does anyone have a recommendation for Goal Seek vs. Solver in terms of
> execution speed? I read somewhere that Solver was a little faster than Goal
> Seek but when I used it though VBA, it seems slower.
>
> Thanks,
> -Adrian
>

[Laurin]

Also keep in mind that if the goal seek target does not differ much from the current value, sometimes goal seek will say it found a solution and doesn't change the "changing cell". Solver does not have this problem.