Sleeper: VBA function "sub not defined"

[dennisvveen]

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!

[Aussiebear]

You could try to rename your Sub, just in case "Solver" is a reserved word in Excel. what does "Solversolve" mean?

[dennisvveen]

SolverSolve means that the solver will run to get a value

[georgiboy]

Might be worth reading the note section of the below:
https://docs.microsoft.com/en-us/office/vba/excel/concepts/functions/solverok-function

[Aussiebear]

SolverSolve means that the solver will run to get a value. I understand that, but in using Solversolve without using the two missing Optional variants doesn't help us to understand where you are trying to get to.