Jun 12 2022
10:10 AM
- last edited on
Feb 01 2023
10:17 AM
by
TechCommunityAP
Jun 12 2022
10:10 AM
- last edited on
Feb 01 2023
10:17 AM
by
TechCommunityAP
I Add a sub and run it in Vbe or View->Macros->Run
Sub test1()
SolverReset
SolverAdd CellRef:="$a$1", Relation:=1, FormulaText:="1"
End Sub
The result is what i need
But when i add a button to run the macro,There is nothing .
after that i modify 1 to 0.99 and run it again.
Sub test1()
SolverReset
SolverAdd CellRef:="$a$1", Relation:=1, FormulaText:="0.9999"
End Sub
Jun 13 2022 01:28 AM