(Solved) – Excel VBA: Compile error: Sub or Function not defined

(solved)-–-excel-vba:-compile-error:-sub-or-function-not-defined

I have an issue with one of my macro in Excel.
It states “Compile error: Sub or Function not defined”

It is super weird because it is a macro that I have created with the record button, and I did not modify the code at any point.

Any help can be appreciated! Thank you

Sub Mod_Compute()
'
' Solving Macro
' Step 4
'

'
    Sheets("Computing table").Select
    Range("T15").Select
    SolverReset
    SolverOk SetCell:="$B$33", MaxMinVal:=2, ValueOf:=0, ByChange:="$B$21:$Q$21", _
        Engine:=2, EngineDesc:="Simplex LP"
    SolverLoad LoadArea:="'Computing table'!$B$36:$M$36"
    SolverOk SetCell:="$B$33", MaxMinVal:=2, ValueOf:=0, ByChange:="$B$21:$Q$21", _
        Engine:=2, EngineDesc:="Simplex LP"
    SolverSolve
    Sheets("User interface").Select

End Sub


Leave a Reply

Your email address will not be published. Required fields are marked *