Microsoft KB Archive/183851

= XL97: Compile Error Running Recorded Macro That Uses Solver =

Article ID: 183851

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q183851



SYMPTOMS
When you run a Visual Basic for Applications macro that you created by using the macro recorder, you may receive the following error message:

Compile error:

Sub or Function not defined



CAUSE
The problem occurs when you run a recorded a macro that uses the Solver add-in and you do not reference the Solver add-in.



RESOLUTION
To resolve this problem, create a reference to the Solver add-in. To create a reference to the Solver add-in, follow these steps:
 * 1) Start the Visual Basic Editor (press OPTION+F11).
 * 2) On the Tools menu, click References.
 * 3) Select Solver, and then click OK.

NOTE: The Solver.xla file is located in the Microsoft Office 98:Office:Excel Add-ins folder

The next time you run the macro, this problem does not occur.



STATUS
This behavior is by design of Microsoft Excel.

