dennisvveen
05-20-2022, 02:55 AM
Hello all,
I can't get my macro to work. The error i get is 'Sub not defined' this is my code
Public Sub Solver()
' Solver Macro
' Keyboard Shortcut: Ctrl+s
SolverOk SetCell:="$AF$3", MaxMinVal:=3, ValueOf:=8.73, ByChange:="$AD$3", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverOk SetCell:="$AF$3", MaxMinVal:=3, ValueOf:=8.73, ByChange:="$AD$3", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverSolve
End Sub
Does anyone know how to define this sub?
Thanks in advance!
I can't get my macro to work. The error i get is 'Sub not defined' this is my code
Public Sub Solver()
' Solver Macro
' Keyboard Shortcut: Ctrl+s
SolverOk SetCell:="$AF$3", MaxMinVal:=3, ValueOf:=8.73, ByChange:="$AD$3", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverOk SetCell:="$AF$3", MaxMinVal:=3, ValueOf:=8.73, ByChange:="$AD$3", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverSolve
End Sub
Does anyone know how to define this sub?
Thanks in advance!