Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can you access the solver reference library in Excel 2002
sp 2 e.g. Sub RunSolver() ' Set up and run Solver. SolverOk SetCell:=Range("PortStdev"), MaxMinVal:=2, _ ByChange:=Range("Weights") SolverAdd CellRef:=Range("SumWts"), Relation:=2, FormulaText:=1 SolverAdd CellRef:=Range("MeanReturn"), Relation:=3, _ FormulaText:="ReqdReturn" SolverOptions AssumeNonNeg:=True SolverSolve UserFinish:=True End Sub I can't establish a reference to the solver library. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. Object Library | Excel Discussion (Misc queries) | |||
Naming word tables or coding reference library with vba | Charts and Charting in Excel | |||
I need to get the reference library from Small Business Financials | Excel Discussion (Misc queries) | |||
How to check Solver and Forms 2.0 Object Library permanently? | Excel Discussion (Misc queries) | |||
Setting up Reference Library using VBA | Excel Programming |