makihussain
New Member
- Joined
- Oct 4, 2015
- Messages
- 11
I got error message when running recorded Macro below in using solver at Bolded blue colour function
Sub Macro2()
'
' Macro2 Macro
'
'
SolverOk SetCell:="$L$4", MaxMinVal:=1, ValueOf:=0, ByChange:="$K$4", Engine:=1 _
, EngineDesc:="GRG Nonlinear"
SolverOk SetCell:="$L$4", MaxMinVal:=1, ValueOf:=0, ByChange:="$K$4", Engine:=1 _
, EngineDesc:="GRG Nonlinear"
SolverSolve
End Sub
Sub Macro2()
'
' Macro2 Macro
'
'
SolverOk SetCell:="$L$4", MaxMinVal:=1, ValueOf:=0, ByChange:="$K$4", Engine:=1 _
, EngineDesc:="GRG Nonlinear"
SolverOk SetCell:="$L$4", MaxMinVal:=1, ValueOf:=0, ByChange:="$K$4", Engine:=1 _
, EngineDesc:="GRG Nonlinear"
SolverSolve
End Sub