Using Excel Solver from VBA

Using the “record macro” icon in Excel to record the solver process, I had a couple of problems:

  • When I tried to run the recorded macro, I got the message “Compile Error – Sub or Function not defined”.
  • When that was fixed the solver worked, but stopped on the final solver screen, rather than returning to the spreadsheet.

The solutions to these problems and many more are given in a detailed article by John Peltier:

Using Solver in Excel VBA

The end result of my work, including open source code, will be covered in my next post.

This entry was posted in Excel, VBA and tagged , , , , . Bookmark the permalink.

1 Response to Using Excel Solver from VBA

  1. Pingback: Asymmetric Catenary Function | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.