Hi Everybody,

I would like to create a macro for using the solver, but i can't. I would
like if the ValueOf could come from a cell, for example the "A1".

That's how it looks now, but I get compile error message:

Sub solver()
'

SolverOk SetCell:="$D$24", MaxMinVal:=3, ValueOf:="600000", ByChange:= _
"$C$8:$C$22"
SolverSolve
End Sub


Thank you in adnvance for your help!
--
sisco98