Compile error: Sub or Function not defined

Did you set a reference to Solver?

Extract from microsoft support:

[I]To reference the Microsoft Excel Solver add-in for macros in your workbook, use the following steps:
Open your workbook.
On the Tools menu, point to Macro, and then click Visual Basic Editor.
On the Tools menu, click References.
In the Available References list, click to select the Solver.xls check box, and then click OK.

Note If you do not see Solver.xls in the Available References list, click Browse. In the Add Reference dialog box, locate and select the Solver.xla file, and then click Open. The Solver.xla file is typically found in the C:\Program Files\Microsoft Office\Office\Library\Solver subfolder.
You are now ready to use the Microsoft Excel Solver functions in a VBA macro./I]

HTH Alf

Thanks Alf. Ticking the Solver box in the VBA References list fixed the problem. When this is done a References folder is displayed in the VBA Project Explorer window which contains the reference to Solver.XLA. Appreciate your help.

Glad to be of help. Don't forget to mark your question "Solved" and if you want to give me a pat on the back click on the scale icon in my post and give a rating to my answer.

Alf

OK. Thread has been marked Solved and I gave you the thumbs up. Cheers.

@Alf
Alf, I am having a similar problem, except Excel does not recognize the "SolverOk" nomenclature (it's highlighted in yellow). I tried checking my references in the VBA editor, but "References" is grayed out so I can't even get into it. Any thoughts?