Compile Error

[nightcrawler23]

Solverok setcell:=Range("I25"), maxminval:=2, _
                      bychange:=Range("F16:O17")

I get the following error while using the solver command


Compile error:
Can't find project or library

Any help!!!!!

 

[Andrew Poulsom]

You need to set a reference to SOLVER (Tools|References in the Visual Basic Editor). If you can't see it in the list activate your worksheet, choose Tools|Solver and click Close.

 

[nightcrawler23]

Thanks I will try..

 

[nightcrawler23]

Hey andrew
I did what u said and i got a solver.xla in my projects window but now i get some other err msg saying
" sub or function not defined"

 

[Andrew Poulsom]

No, in the VBE click your workbook in the Projects window. Then choose Tools|References, check SOLVER and click OK.

 

[nightcrawler23]

Thanks it worked......