VBA Run Solver Macro

[chillepepper101]

Evening all!

I have just joined the forum, great to see so many people helping each other, I hope as I learn more I can add something!

I do have a problem I am trying to solve and wonder if I could ask for help please. Any help is much appreciated.

I am trying to make a VBA button to run solver in Excel 2010. I have managed all the solver and am happy with this and tried using the record button simply to activate that work but unfortunatley I cant get it to work. I have tried to attach the spreadsheet here but dont think I can unfortunately.

Is there anyone who may now how to make this run please. Its just a solver to optimise the U Stat (cell N6) by adjusting the figures in Alpha (cell Q2), Beta (Q3), and Gamma (Q4) between 0 and 1.

Any help or advise is much appreciated. I copy the macro recorded below in case for some people its obvious what I have missed!

Sub VBASolverUSTAT()
'
' VBASolverUSTAT Macro
'

'
SolverOk SetCell:="$N$6", MaxMinVal:=2, ValueOf:=0, ByChange:="$Q$2:$Q$4", _
Engine:=3, EngineDesc:="Evolutionary"
SolverSolve
End Sub

I can't seem to attach the spreadsheet, is this not possible in order to protect people from viruses etc? Im hoping its now attached!

Best regards,

Paul

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[zbor]

Thread opened in Commercial services subforum so I'm closing this one.