Solver Macro
 

Hi Everyone,

I am trying to write a macro for the solver function with the
following parameters:

Set Target Cell: = AW20
Value of := 490,000
By Changing:= G18:AW18

Subject to:
D33:Z33 = 0
D38:Z38 =1.18
E18:AW18 = 440,000
E39:Z39 = 5,000
E40:Z40 = 50,000

Can anyone assist me with the codes for this.

Also is it possible to use range names as oppose to absolute values
for some of the contraints within the macro?

Thanks in advance for helping.

Best regards

Lacty