Hello all,
I can't get my macro to work. The error i get is 'Sub not defined' this is my code
Does anyone know how to define this sub?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
Thanks in advance!