Solver macro

[Whiox]

Dear Excel community

Goal
I'd like to write a VBA macro using Solver.
I've no previous experience with macros.
I am looking for a dummy guide please.

Solver input
Set Objective: 'Calc optimised'!$J$14
To: Min
By changing variable cells: 'Calc optimised'!$E$3
Subject to the constraints:
'Calc optimised'!$E$3 => 0
'Calc optimised'!$E$3 <= 'Calc optimised'!$E$2

Make unconstrained variables non-negative: yes (note: not sure whether this is important)
Solving method: evolutionary


Thank you

 

[Jon Peltier]

Re: Help with solver macro please

Worksheets("Sheet1").Activate