Hello,
I've written the below code to leverage Solver. I'd like to RoundDown the answer the code churns out but have been having trouble getting it to work. I've been trying to leverage Application.WorksheetFunction.RoundDown, but can't seem to get it to work. Any help would be greatly appreciated. Below is the code for the solver:
SubBreakevenTgtDflt()
'
' BreakevenTgtDfltMacro
'
Application.Run "SolverReset"
Application.Run "SolverAdd","TargDflt3", 2, ".00001"
Application.Run "SolverOk","$J$29", 2, "0", "TargDflt3", 2
Application.Run "SolverSolve",True
End Sub
I've written the below code to leverage Solver. I'd like to RoundDown the answer the code churns out but have been having trouble getting it to work. I've been trying to leverage Application.WorksheetFunction.RoundDown, but can't seem to get it to work. Any help would be greatly appreciated. Below is the code for the solver:
SubBreakevenTgtDflt()
'
' BreakevenTgtDfltMacro
'
Application.Run "SolverReset"
Application.Run "SolverAdd","TargDflt3", 2, ".00001"
Application.Run "SolverOk","$J$29", 2, "0", "TargDflt3", 2
Application.Run "SolverSolve",True
End Sub
