Results 1 to 2 of 2
2001-11-16, 14:59 #1jjabarryGuest
Excel Solver in VBA? (Excel 2000)
Does anyone have an example code of how to include the Solver function in a macro and can you set up some variables where a message box asks for the target cell and the cell you want to change to approach the value of interest. In other words, get cell B1 to match A1 by changing cell C1.
2001-11-16, 17:04 #2
- Join Date
- Jun 2001
- New York, New York, Lebanon
- Thanked 1 Time in 1 Post
Re: Excel Solver in VBA? (Excel 2000)
I tried to record while I was working with solver and here is what I got:
SolverOk SetCell:="$A$2", MaxMinVal:=1, ValueOf:="0", ByChange:="$A$1,$A$6"
I hope I gave you an example...
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>