Using solver in Excel VBA on mac

Question

I want to automate a series of solver operations in a VBA macro in Excel 2016 for mac. However, when I run the macro an error keeps popping up. The error I get is "Sub of function not defined". The code I use is the following.

Sub test_test_test()
'
' test_test_test Macro
'
    SolverOk SetCell:="$K$3", MaxMinVal:=3, ValueOf:=-20, ByChange:="$K$3", Engine:=1, EngineDesc:="GRG Nonlinear"
    SolverSolve

End Sub

Thanks a lot! Lennart

This may help msdn.microsoft.com/en-us/library/office/ff839427.aspx — Gordon
– Gordon, Commented Feb 15, 2017 at 13:43

Mehmet Yusuf Çakmak · Accepted Answer · 2017-11-26 13:17:50Z

2

You should add solver to references.

To do so, open visual basic editor. There is "Add References ...." button on bottom left of the editor. Click it, check the box for Solver, then click OK. This should work.

answered Nov 26, 2017 at 13:17

Mehmet Yusuf Çakmak

1368 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using solver in Excel VBA on mac

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related