Hi. You just need to set a reference to Solver in vba.
Here are the steps...

http://support.microsoft.com/kb/213689/en-us

Good luck.

[The error message is "Sub or Function not defined"]

--
Dana DeLouis
Windows XP & Office 2003


"JamesB" wrote in message
...
Hey guys,

Thanks for your assistance.

I'm having some problems still with the Macro thing (first shot at it). I
basically just "started recording a macro", performed the solver task
(i.e.
Tools Solver Set Target Cell etc. Solve) then "stopped recording". I
saved the worksheet, then tried to run the macro and got the following:

<img src="http://img136.imageshack.us/img136/8928/excelscreenshotog7.png"
Does this make sense to you?
Apologies for my naivety.
Again, appreciate your help!

<snip