how to use Solver in Excel VBA

[mvanhelden]

Hi all,

I'm trying to use solver to minimize a cell for a least squares regression. The minimization cell is a weighted sum of squared residuals. Three variables exist that define the regression line. Another six cells define the bounds for the variables.

I get the following error:

Compile Error: Sub or Function not defined

Here is the code:

Please Login or Register  to view this content.

Any help please?

[Alf]

Before you can use the Solver VBA functions in the Visual Basic Editor, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select Solver under Available References. If Solver does not appear under Available References, click Browse, and then open Solver.xlam in the \Program Files\Microsoft Office\Office14\Library\SOLVER subfolder.

You also should add code tags to your macro or the moderators will be upset.

Alf

[mvanhelden]

Thanks Alf!

That's a great help. I figured it was something like that. I'll try it out and post the results soon.

All the best,

mvanhelden

[Cutter]

@ mvanhelden

Welcome to the forum.

Please notice that code tags have been added to your post(s). As Alf pointed out, the forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

Also, by failing to add the code tags after their required usage was pointed out to you by Alf, you broke rule #7. And that's much more likely to "upset the moderators".

[mvanhelden]

didn't mean to upset anyone. just new to this and didn't understand "the rules".

Thanks for the help, Alf.

[Cutter]

Nobody's upset. But you should familiarize yourself with the rules.

[Alf]

Thanks for the help, Alf.

Glad to be of help.

Alf

Ps: If this solves your problem don't forget to mark your thread "solved"

Rule #9

and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.