Your past setting a reference to the Solver Addin?
http://support.microsoft.com/default...b;en-us;843304
How to create Visual Basic macros by using Excel Solver in Excel 97
--
regards,
Tom Ogilvy
"lahbib" wrote:
even when i add SOLVER to references
i tried the same thing with another pc, and it worked well
--
lahbib
------------------------------------------------------------------------
lahbib's Profile: http://www.excelforum.com/member.php...o&userid=35038
View this thread: http://www.excelforum.com/showthread...hreadid=547859