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

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 ,
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

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.


--
Laurin
------------------------------------------------------------------------
Laurin's Profile: http://www.excelforum.com/member.php...o&userid=26832
View this thread: http://www.excelforum.com/showthread...hreadid=383721