I get this when I record a Macro using the solver
SolverOk SetCell:="$A$3", MaxMinVal:=1, ValueOf:="0", ByChange:="$A$1:$A$2"
SolverAdd CellRef:="$A$1", Relation:=1, FormulaText:="10,234"
SolverAdd CellRef:="$A$2", Relation:=1, FormulaText:="5,543"
SolverSolve
SOlverReset
And this code works but ONLY ONCE. When I copy this code into a controlbutton and run IT AGAIN 10,234 is READ like 10234 and "5,543" is read like "5543"
I've tried
SolverAdd CellRef:="$A$1", Relation:=1, FormulaText:=10.234
AND it GET THE SAME RESULT THAT IS 10234...
imAYBY IT'S SOMETHING WRONG WITH THE REFERENCE SOLVER.XLS THAT I USE? CAN IT BE UPDATED?
AGAIN i'VE OFFICE 2000
Bookmarks