Help needed

[HussainSA]

Hello,
when I run this macro a message shows that Error: Sub or Function not defined. The code is as follows-

>>> use code - tags <<<

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+m
'
    SolverOk SetCell:="$I$49", MaxMinVal:=1, ValueOf:=0, ByChange:="$C$37:$C$46", _
        Engine:=1, EngineDesc:="GRG Nonlinear"
    SolverOk SetCell:="$I$49", MaxMinVal:=1, ValueOf:=0, ByChange:="$C$37:$C$46", _
        Engine:=1, EngineDesc:="GRG Nonlinear"
    SolverSolve
End Sub

Can anyone find the error and correct it?

 

[vletm]

HussainSA
Have You done below?

Using the Solver VBA Functions

Office VBA reference topic

docs.microsoft.com

... as well as - have You read and followed below?

SolverOk Function

Office VBA reference topic

docs.microsoft.com

 

[HussainSA]

HussainSA
Have You done below?

Using the Solver VBA Functions

Office VBA reference topic

docs.microsoft.com

... as well as - have You read and followed below?

SolverOk Function

Office VBA reference topic

docs.microsoft.com

The problem is running macro.

 

[vletm]

HussainSA
Which macro?
Did You follow my writings?

 

[Marc L]

HussainSA, according to any forum rules you should modify your thread title according to your issue as every thread 'needs help' …​

​