Has anyone had any trouble using the SOLVER function in Excel XP VBA?

[MrMeReturns]

I have been trying to get the Solver to run in Excel XP VBA but I keep getting an error saying an unexpected error has occured or the machine has run out of resources.

Also the function text itself is acting a bit wierd. Instead of turning blue and capitalizing the appropriate letters like other functions, the solver function calls remain as if they were normal text - all lower case and black.

This is the peice of code that is giving me the error.

SolverOk SetCell:=ActiveSheet.Range("A1&quot, MaxMinVal:=3, ValueOf:="0", ByChange:=ActiveSheet.Range("A2&quot

Note I corrected the formatting manually.

If anyone has anyideas let me know please

MrMeReturns

 

[ETID]

Im thinking it's the quotes in ....ValueOf:="0"

try just ValueOf:= 0

 

[RobBroekhuis]

Have you established a reference to the Analysis Toolpak in VBE? From Excel proper, you can add "Analysis ToolPak - VBA" as an AddIn, but I think there is also a route via Tools-References in the VBE. Can't seem to find it right now, though.
Rob