Thanks for the link and the 'heads up' Dana - much appreciated. :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Dana DeLouis" wrote in message
...
For you reference, I am running Windows 2000, Excel 2000
SP-3

XL2000: The Solver Add-in May Not Work When You Start Solver by Using a
Macro

http://support.microsoft.com/default...30&Product=xlw

CAUSE
This problem may occur after you install Microsoft Office 2000 Service Pack
3 (SP-3).

HTH.

SolverSolve (True)

As a side note, although it works, it may be slightly better to not include
() around the "True" statement. They are "usually" used when testing the
results of Solver, as in the following idea...

Sub ExampleSolve()
Dim Result
SolverReset '<- Clean up
SolverOk [A3], 3, 10, [A1]
Result = SolverSolve(True)
'Or
SolverSolve True
End Sub

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =

<snip




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.571 / Virus Database: 361 - Release Date: 26/01/2004