Solver Macro

[Lacty]

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

 

[merjet]

Download the file here:
http://download.microsoft.com/download/excel97win/solverex/1.0/win98me/en-us/solverex.exe
Use the macro New_Employee_Schedule() as a guide. It has constraints.
Yes, you can use a range-name in lieu of cell addresses.
Don't forget to set a reference. See http://support.microsoft.com/kb/843304
for more info.

Hth,
Merjet

 

[Jon Peltier]

Turn on the macro recorder, run this analysis manually, then fix up the
code.

- Jon