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